CS403 Quiz No.4 Shared by Neha

Question # 1 of 10 ( Start time: 10:22:34 PM ) Total Marks: 1
Identify the basic part(s) of a SELECT statement?
Select correct option:
SELECT
FROM
Both SELECT and FROM
DISTINCT


Question # 2 of 10 ( Start time: 10:23:12 PM ) Total Marks: 1
Which of the following is incorrect about alter table statement?
Select correct option:
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 # 3 of 10 ( Start time: 10:23:53 PM ) Total Marks: 1
Which of the following is the correct syntax for adding a new column into an existing table.
Select correct option:
ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
Both I and II.
None of the above.


Question # 4 of 10 ( Start time: 10:24:28 PM ) Total Marks: 1
Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
Select correct option:
DISTINCT
DELETE
UPDATE
ALTER


Question # 5 of 10 ( Start time: 10:25:11 PM ) Total Marks: 1
The ____________ keyword is used in SELECT statement to return different values.
Select correct option:
LIKE
IN   
DISTINCT
WHERE


Question # 6 of 10 ( Start time: 10:26:06 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 # 8 of 10 ( Start time: 10:28:09 PM ) Total Marks: 1
Functions in SQL return a single value
Select correct option:
True
False


Question # 9 of 10 ( Start time: 10:28:42 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 # 10 of 10 ( Start time: 10:29:10 PM ) Total Marks: 1
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.