Blog: CS403 Quiz 25 to Lecture 32 File 2

Question No. 1
 Which of the fllowing clauses allows to sort the records in result set?
     ►Where
     ►Order by
     ►From
     ►Having

Question No. 2
 Which of the following SQL statements used to control access to the data and to the database?
     ►Grant
     ►Revoke
     ►Both Grant and Revoke
     ►Select


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

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

Question No. 5
 Which of the following is not an aggregate function
     ►AVG
     ►SUM
     ►UPPER
     ►MAX

Question No. 6
 _______ Operators are the ones that require two operands on both sides of the operator.
     ►Double
     ►Tow Sided
     ►Binary
     ►None of the given options


Question No. 7
 What happened if the Where clause is omitted from a Delete Statement?
     ►All record from the table are deleted
     ►No record from the tables will be deleted
     ►First record of the tables will be deleted
     ►The statement will not be executed and will give a syntax error


Question No. 8
 Grant belong to which types of SQL command classification
     ►DML
     ►DDL
     ►DCL
     ►DQL

Question No. 9
 Update command belong to which type of classification
     ►DML
     ►DDL
     ►DCL
     ►DQL


Question No. 10
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. 11
 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
     ►Suitable to relatively static situations
     ►It is a process, which means to place record from different tables to places in adjacent physical locations.

Question No. 12
 Truncate command responses time is ____________ as compared to delete command.
     ►Poor
     ►Same
     ►Better
     ►Worst

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

Question No. 14
Revoke is a __________ Statement
     ►Data Definition
     ►Control Access
     ►Data Manipulation
     ►Data Description

Question No. 15
 GRANT is a _____________ command.
     ►DDL
     ►DML
     ►DCL
     ►None of the above

Question No. 16
 Which of the following is one of the purposes of using DDL commands?
     ►Inserting records into databases
     ►Updating records into databases
     ►Manipulation databases
     ►Creating and destroying databases


Question No. 17
 Which of the following is not a part of an INSERT statement?
Select correct option:
     ►INTO
     ►VALUES
     ►INSERT
     ►MODIFY

Question No. 18
 Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’ ORDERBY Age;
     ►The statement has a syntax error
     ►The statement displays the entire fields from emp in which the Empname is ALI in any order
     ►The statement displays the entire fields from emp in which the Empname is ALI in descending order of their age
     ►The statement displays the entire fields from emp in which the Empname is ALI in ascending order of their age

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

Question No. 20
 In SQL, which command is used to delete rows from table.
Select correct option:
     ►DELETE
     ►REMOVE
     ►TRUNCATE
     ►Both I and II