Blog: CS403 Quiz 25 to Lecture 32 File 1

CS403- Database Management System

Quiz No. 3

Dated 13-01-2012

Dear Students,

Quiz No. 03 of CS403 - DBMS, would held on January 13, 2012 (Friday) and will be open for 24 hours (1 Day). Quiz would be from Lecture 25 to Lecture 32

Question No. 1

Which of the following is one of the purposes of using DDL commands?
     ►inserting records into databases
     ►updating records into databases
     ►manipulating databases
     ►creating and destroying databases


Question No. 2
Which of the following is incorrect about alter table statement?
     ►Cannot be used to modify type or size of an existing column                
     ►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

Question No. 3
Which of the following is used to retrieve and insert information from database?
     ►DML
     ►DDL
     ►DCL
     ►Both DML and DDL

Question No. 4
Which of the following is used with INSERT command to insert values in a DB table?
     ►ONTO
     ►INTO
     ►UPTO
     ►WITH

Question No. 5
In SQL, which command is used to modify the rows of tables.
     ►Update
     ►Insert
     ►Browse
     ►Append

Question No. 6
Identify the basic part(s) of a SELECT statement?
     ►SELECT
     ►FROM
     ►Both SELECT and FROM
     ►DISTINCT

Question No. 7
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
     ►True
     ►False

Question No. 8
Objective of an order by clause is to display or arrange output of a select statement in a particular order.
     ►True
     ►False

Question No. 9
 Which of the following is not a part of an INSERT statement?
     ►INTO
     ►VALUE
     ►INSERT
     ►Modify


Question No. 10
 The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:

     ►IN
     ►FROM
     ►LIKE 
     ►None of the above.

Question No. 11
Which of the following is not an aggregate function
Select correct option:
     ►AVG
     ►SUM
     ►UPPER
     ►MAX

Question No. 12
UPDATE command belongs to which type of Classification
Select correct option:
     ►DML
     ►DDL
     ►DCL
     ►DQL


Question No. 13
GRANT belongs to which type of SQL commands classification
Select correct option:

     ►DML
     ►DDL
     ►DCL
     ►DQL


Question No. 14
DML does not used to :
Select correct option:
     ►add new rows to tables
     ►retrieve rows from table
     ►modify the rows of tables
     ►alter a table definition



Question No. 15
Which of the following SQL statements used to control access to the data and to the database?
Select correct option:

     ►GRANT
     ►REVOKE
     ►Both GRANT and REVOKE
     ►SELECT

Question No. 16
 Which of the following is the correct syntax for adding a new column into an existing table.
Select correct option:

     ►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.
     ►None of the above.


Question No. 17
 DML does not used to
     ►Add new Rows to tables
     ►Retrieve Rows from table
     ►Modify the rows of tables
     ►Alter table definition

Question No. 18
 The _________ function helps reduce the need to use mutiple OR conditions.
     ►Like
     ►IN
     ►AND
     ►Between

Question No. 19
 Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
     ►TRUE
     ►FALSE

Question No.20
 In SQL, which command is used to delete rows from table.
     ►Delete
     ►Remove
     ►Truncate
     ►Both I and II