CS403 Quiz No.4 Shared by Fozia Munir

Question # 2 of 10 ( Start time: 10:03:10 PM ) Total Marks: 1
Which of the fllowing clauses allows to sort the records in result set?
Select correct option:
where
order by
from
having


Question # 3 of 10 ( Start time: 10:04:43 PM ) Total Marks: 1
REVOKE is a ______________ statement.
Select correct option:
Data Definition
Control Access
Data manipulation
Data description


Question # 4 of 10 ( Start time: 10:05:27 PM ) Total Marks: 1
Which of the following function falls in the category of Aggregate functions.
Select correct option:
SUM
MIN
MAX
All of the above


Question # 6 of 10 ( Start time: 10:07:35 PM ) Total Marks: 1
Which of the following is a String function in SQL
Select correct option:
COUNT
LEN
SQRT
SIN


Question # 7 of 10 ( Start time: 10:08:37 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 # 8 of 10 ( Start time: 10:09:26 PM ) Total Marks: 1
Which of the following is not an aggregate function
Select correct option:
AVG
SUM
UPPER
MAX


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


Question # 10 of 10 ( Start time: 10:11:29 PM ) Total Marks: 1
In SQL, which command is used to modify the rows of tables.
Select correct option:
UPDATE
INSERT
BROWSE
APPEND