CS403 Quiz No.2 Shared by Shehzad

Question # 1 of 10 ( Start time: 10:50:58 AM )  Total Marks: 1
Which of the following is not a part of an INSERT statement?
Select correct option:
 INTO
 VALUES
 INSERT
 MODIFY


Question # 2 of 10 ( Start time: 10:51:25 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: 10:52:52 AM )  Total Marks: 1
In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.
Select correct option:
Access data from both the vertical partitions.
Access data from first vertical partition.
Access data from second vertical partition
None of the above.


Question # 4 of 10 ( Start time: 10:52:52 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 # 5 of 10 ( Start time: 10:52:52 AM )  Total Marks: 1
SQL is used for:
Select correct option:
Creating, managing and deleting tables and manage the relationships among the stored date.
Generating queries, organizing, managing and retrieving data stored in a database.
Maintaining data integrity and coordinate data sharing.
All of the above


Question # 6 of 10 ( Start time: 10:52:52 AM )  Total Marks: 1
Objective of an order by clause is to display or arrange output of a select statement in a particular order.
Select correct option :
True
False

Question # 7 of 10 ( Start time: 10:52:52 AM )  Total Marks: 1
We should not compromise ________ over efficiency.
Select correct option:
 Consistency
 Normalization
 Query response time
 All of the above

Question # 8 of 10 ( Start time: 10:52:52 AM )  Total Marks: 1
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition


Question # 9 of 10 ( Start time: 10:52:52 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 # 10 of 10 ( Start time: 10:52:52 AM )  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