Blog: CS403 Quiz 25 to Lecture 32 File 3

Question No. 1
 In SQL queries, while creating tables or relations in database, key columns may be specified by
Select correct option:
     ►Null
     ►Not Null
     ►Data Type
     ►None of the above

Question No. 2
 What happens if the WHERE clause is omitted from a DELETE statement?
     ►All records from the table are deleted
     ►No record from the table will be deleted
     ►First record of the table will be deleted
     ►The statement will not be executed and will give a syntax error

Question No. 3
 Truncate command response time is ____ as compared to Delete command.
Select correct option:
     ►Poor
     ►Same
     ►Better
     ►worst


Question No. 4
 Which of the following syntax of the functions in SQL is used to add column values?
Select correct option:
     ►COUNT(*)
     ►COUNT(expression)
     ►MAX(expression)
     ►SUM(expression) Not Sure

Question No. 5
 Which of the following is used to retrieve and insert information from database?
Select correct option:
     ►DML
     ►DDL
     ►DCL
     ►Both DML and DDL


Question No. 6
 Which of the following is used to filter rows according to some condition(s)?
Select correct option:
     ►SELECT
     ►FROM
     ►WHERE
     ►UPDATE

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

Question No. 8
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
     ►SELECT FROM * Persons
     ►SELECT * FROM Persons
     ►SELECT * WHERE Persons
     ►SELECT WHERE * Persons


Question No. 9
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. 10
Which of the following statements creates a database named IMDB.
Select correct option:
     ►CREATE DATABASE IMDB;
     ►CREATE DB IMDB;
     ►ADD DATABASE named IMDB;
     ►CREATE IMDB DATABASE;

Question No. 11
Which of the following is not true regarding clustering?
Select correct option:
     ►It increases the efficiency since related records are placed close to each other
     ►Clustering makes records, difficult to access
     ►Suitable to relatively static situations.
     ►It is a process, which means to place records from different tables to place in adjacent physical locations

Question No. 12
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
     ►SELECT
     ►FROM
     ►WHERE
     ►UPDATE

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

Question No. 14
CREATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
     ►DML
     ►DDL
     ►DCL
     ►DQL


Question No. 15
In SQL, which command is used to modify the rows of tables.
Select correct option:
     ►UPDATE
     ►INSERT
     ►BROWSE
     ►APPEND


Question No. 16
SQL is used for:
Select correct option:
     ►Creating, managing and deleting tables and manage the relationships among the stored date.
     ►Generating queries, organizing, managing and retrieving data stored in a database.
     ►Maintaining data integrity and coordinate data sharing.
     ►All of the above

Question No. 17
Which of the following is used to filter rows according to some condition(s)?
Select correct option:

     ►SELECT
     ►FROM
     ►WHERE 
     ►UPDATE

Question No. 18
 Which language is used to permit or prohibit access to a table?
Select correct option:
     ►DCL 
     ►DDL
     ►DML
     ►All of the above.

Question No. 19
Which of the following is a String function in SQL
     ►COUNT
     ►LEN 
     ►SQRT
     ►SIN


Question No. 20
Truncate is an alternative of Delete command.
Select correct option:
     ►True 
     ►False


Question No. 21
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