CS403 Quiz No.3 Shared by Junaid

Question # 1 of 10 ( Start time: 12:23:34 PM )  Total Marks: 1
Is the given SQL Statement prompt error? Select * from relation1;
Select correct option:
 Logical Error
 No Error       ok
 Parameter Error
 Time out Error


Question # 2 of 10 ( Start time: 12:24:01 PM )  Total Marks: 1
REVOKE is a ______________ statement.
Select correct option:
 Data Definition
 Control Access   ok
 Data manipulation
 Data description


Question # 3 of 10 ( Start time: 12:25:23 PM )  Total Marks: 1
Functions in SQL return a single value
Select correct option:
 True   ok
 False


Question # 4 of 10 ( Start time: 12:26:05 PM )  Total Marks: 1
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)  ok


Question # 5 of 10 ( Start time: 12:26:24 PM )  Total Marks: 1
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’;
Select correct option:
 The statement has a syntax error
 The statement only displays the EmpID of those employees whose name is ALI
 The statement displays the entire fields from emp in which the Empname is ALI  ok
 The statement must have an ORDERBY clause


Question # 6 of 10 ( Start time: 12:26:45 PM )  Total Marks: 1
DML stands for _____________.
Select correct option:
 Dynamic Modeling Language
 Data Manipulation Language  ok
 Data Management Language
 Domain Modeling Language


Question # 7 of 10 ( Start time: 12:27:05 PM )  Total Marks: 1
Truncate command response time is ______ as compared to Delete command.
Select correct option:
 Poor
 Same
 Better  ok
 worst


Question # 8 of 10 ( Start time: 12:27:19 PM )  Total Marks: 1
Which language is used to permit or prohibit access to a table?
Select correct option:
 DCL
 DDL 
 DML
 All of the above.


Question # 9 of 10 ( Start time: 12:28:15 PM )  Total Marks: 1
GRANT is a ______________ Command.
Select correct option:
 DDL
 DML
 DCL    ok
 None of the above


Question # 10 of 10 ( Start time: 12:29:39 PM )  Total Marks: 1
Suppose we have two tables T1 and T2. Tuples of T1 that do not match some row in T2 will not appear in
Select correct option:
 Outer Join
 Inner Join  ok
 Both I and II
 None of the above