CS403 Current Quiz

Question # 1 of 10 ( Start time: 10:58:28 AM ) Total Marks: 1 

The _________ function helps reduce the need to use mutiple OR conditions.
Select correct option:

Like
IN
AND
BETWEEN


Question # 2 of 10 ( Start time: 10:59:54 AM ) Total Marks: 1
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
Select correct option:

True
False

Question # 3 of 10 ( Start time: 11:01:06 AM ) Total Marks: 1
In SQL, which command is used to delete rows from table.
Select correct option:

DELETE
REMOVE
TRUNCATE
Both I and II


Question # 4 of 10 ( Start time: 11:02:48 AM ) 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 # 5 of 10 ( Start time: 11:03:50 AM ) Total Marks: 1
Which of the following statements creates a database named IMDB.
Select correct option:

Question # 6 of 10 ( Start time: 11:05:29 AM ) Total Marks: 1
Which of the following SQL statements used to control access to the data and to the database?
Select correct option:

GRANT
REVOKE
Both GRANT and REVOKE
SELECT

Question # 7 of 10 ( Start time: 11:06:30 AM ) Total Marks: 1
Which of the following is used with INSERT command to insert values in a DB table?
Select correct option:

ONTO
INTO
UPTO
WITH

Question # 8 of 10 ( Start time: 11:08:05 AM ) Total Marks: 1
Which of the following is used to retrieve and insert information from database?
Select correct option:

DML
DDL
DCL
Both DML and DDL

Question # 9 of 10 ( Start time: 11:09:27 AM ) Total Marks: 1
In SQL queries, while creating tables or relations in database, key columns may be specified by
Select correct option:

Null
Not Null
Data Type
None of the above

Question # 10 of 10 ( Start time: 11:10:53 AM ) Total Marks: 1
Which of the following is not an aggregate function
Select correct option:

AVG
SUM
UPPER
MAX