We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Quizz No 3: CS403 (Database Management System) will be opened on 10th July, 2014 and last date 11th July, 2014

DEAR STUDENT:

It is to remind that quiz 03 of CS403 (Database Management System) will be opened on 10th July, 2014 and last date to attempt quiz will be 11th July, 2014

including lectures from 26 to 30.


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 7446

Replies to This Discussion

MY TODAY QUIZZ.......

1:     Which of the following is used to filter rows according to some condition(s)?

  • SELECT
  • FROM
  • WHERE( true)

Question # 2 of 10 ( Start time: 04:17:05 PM ) Total Marks: 1 The _________ function helps reduce the need to use mutiple OR conditions.

  • Like
  • IN( true)
  • AND 
  • BETWEEN

3:-   Which of the following is incorrect about alter table statement?

  • Cannot be used to modify type or size of an existing column ( true)
  • Can be used to delete a column
  • Can not be used to create a new table
  • Can be used to add column in the existing table

4:-  The ________ condition allows to retrieve values within a specific range.

  • in
  • And
  • like
  • between (true)

5:   Which of the following is not true regarding clustering?

  • It increases the efficiency since related records are placed close to each other
  • Clustering makes records, difficult to access (true)
  • suitable to relatively static situations
  • It is a process, which means to place records from different tables to place in adjacent physical locations

6:   In SQL, which command is used to modify the rows of tables.

  • UPDATE (true)
  • INSERT
  • BROWES
  • APPEND

7:    Which of the fllowing clauses allows to sort the records in result set?

  • where
  • order by (true)
  • From 
  • Having

8:   Which of the following SQL statements used to control access to the data and to the database?

  • grant
  • revoke
  • both 1 and 2 (true)
  • select

9:    In SQL, which command is used to delete rows from table.

  • delete (true)
  • remove

10:   Which of the following is a String function in SQL

  • count
  • len (true)
  • sqrt
  • Sin

1:    Which of the fllowing clauses allows to sort the records in result set?\

  • where
  • order by (true)
  • from
  • having

2:      Which of the following is used to retrieve and insert information from database?

  • DML (true)
  • DDL
  • DCL
  • Both DML and DDL

3:    Which of the following is the correct syntax for adding a new column into an existing table.

  • ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
  • ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
  • Both I and II. (true)
  • None of the above.

4:     Which of the following is not true regarding clustering?

  • It increases the efficiency since related records are placed close to each other
  • Clustering makes records, difficult to access (true)
  • suitable to relatively static situations.

5:     In SQL, which command is used to modify the rows of tables.

  • update (true)

6:    The ____________ keyword is used in SELECT statement to return different values.

  • distinct ( true)

7:     Which of the following is a String function in SQL

  • COUNT
  • LEN (true)
  • SIN
  • SQL

8:    The _________ function helps reduce the need to use mutiple OR conditions.

  • Like
  • IN (true)
  • AND
  • BETWEEN

9:   Identify the basic part(s) of a SELECT statement?

  • SELECT
  • FROM
  • BOTH SELECT AND FROM( true)

10:    What happens if the WHERE clause is omitted from a DELETE statement?

  • all data(record) will be effected (true)

1:-Which of the following is not an aggregate function

  • AVG
  • SUM
  • UPPER
  • MAX (true)

2:   UPDATE command belongs to which type of Classification

  • DML( true)
  • DDL
  • DCL
  • DQL

3:   Which of the following is not a part of an INSERT statement?

  • INTO
  • VALUES
  • INSERT
  • MODIFY( true)

4:   Which of the following is used with INSERT command to insert values in a DB table?

  • ONTO
  • INTO (true)
  • UPTO
  • WITH

5:-   Objective of an order by clause is to display or arrange output of a select statement in a particular order.

  • T (ture ans)
  • F

6:  The ________ operator allows to use wild cards in the where clause of an SQL statement.

  • LIKE (true)
  • IN
  • NOne of the option
  • FROM

7:    In SQL, which command is used to delete rows from table.

  • DELETE (true)
  • REMOVE
  • TRUNCATE

8:   Identify the basic part(s) of a SELECT statement?

  • SELECT
  • FROM
  • BOTH SELECT AND FROM (true)

9:    The ____________ keyword is used in SELECT statement to return different values.

  • LIKE
  • IN
  • Distinct (true)

10:   Which of the following prevents duplicate values to be displayed as a result of an SQL statement?

  • DISTINCT( true)
  • DELETE
  • UPDATE

my quiz No.3 of cs403

date:11-07-2014

check it and correct the errors.

Adnan Butt

Attachments:

RSS

Looking For Something? Search Here

Latest Activity

Zohaib Hassan updated their profile
1 hour ago
Mani Siddiqui BS VIII posted discussions
1 hour ago
Mani Siddiqui BS VIII posted a status
"کسی بھی روز مجھے دل سزا سنا دے گا میں خواہشوں کا بہت قتلِ عام کرتا ہوں ,,,!!"
3 hours ago
ღ*`* Mute Kuri *`*ღ liked Ellen Shades's blog post One Lesson Book - The Graphic Design
3 hours ago
Mani Siddiqui BS VIII replied to Mani Siddiqui BS VIII's discussion Ms or Certifications !!!!
5 hours ago
Zohaib Hassan posted a discussion
5 hours ago
Laila kabeer posted a discussion
6 hours ago
Zohaib Hassan replied to Bakhtawar khan's discussion <<<<<hann g>>>>>>>>
7 hours ago

HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.