CS403 Quiz No.3 Shared by Life

Question # 1 of 10 ( Start time: 06:28:10 PM ) Total Marks: 1
Value of a function in SQL is always determined by the input parameters
Select correct option:
True
False


Question # 2 of 10 ( Start time: 06:28:59 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
Both I and II
None of the above


Question # 3 of 10 ( Start time: 06:29:20 PM ) Total Marks: 1
Which of the following is not DML command?
Select correct option:
Select
Update
Delete
Truncate


Question # 4 of 10 ( Start time: 06:30:23 PM ) Total Marks: 1
DML stands for _____________.
Select correct option:
Dynamic Modeling Language
Data Manipulation Language
Data Management Language
Domain Modeling Language


Question # 5 of 10 ( Start time: 06:30:52 PM ) Total Marks: 1
Functions in SQL return a single value
Select correct option:
True
False


Question # 6 of 10 ( Start time: 06:30:52 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’;
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
The statement must have an ORDERBY clause


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


Question # 8 of 10 ( Start time: 06:32:08 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: 06:32:08 PM ) Total Marks: 1
Consider the two relations, Supplier (S_no, S_name, Contact_No, Address) and Supply (S_no, Item_no). Which of the following statements give(s) a list of supplier names supplying the item with Item_no ‘555’?
SELECT S_name FROM Supplier WHERE Item_no=’555’
SELECT S_name FROM Supplier, Supply WHERE Supplier.S_no=Supply.S_no AND Item_no=’555’
SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supply WHERE Item_no=’555’)
SELECT S_name FROM Supplier WHERE S_name EXISTS (SELECT S_name FROM


Question # 10 of 10 ( Start time: 06:32:58 PM ) Total Marks: 1
GRANT is a ______________ Command.
Select correct option:
DDL
DML
DCL
None of the above