CS403 Current Quiz

Consistency

MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 51
sec(s)



Question # 1 of 10 ( Start time: 04:51:50 PM ) Total Marks: 1
We should not compromise ________ over efficiency.
Select correct option:



MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 58
sec(s)



Question # 2 of 10 ( Start time: 04:52:59 PM ) Total Marks: 1
Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address), where roll no is PK
Select correct option:


MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 64
sec(s)



Question # 3 of 10 ( Start time: 04:54:08 PM ) 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:

MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 52
sec(s)



Question # 4 of 10 ( Start time: 04:54:40 PM ) Total Marks: 1
BCNF is needed because
Select correct option:


MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 56
sec(s)



Question # 5 of 10 ( Start time: 04:56:01 PM ) Total Marks: 1
Which of the following statements creates a database named IMDB.
Select correct option:



MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 73
sec(s)



Question # 6 of 10 ( Start time: 04:56:40 PM ) Total Marks: 1
Which of the following is one of the purposes of using DDL commands?
Select correct option:



MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 83
sec(s)



Question # 7 of 10 ( Start time: 04:57:03 PM ) Total Marks: 1
A second Normal Form (2 NF) relation should
Select correct option:




MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 58
sec(s)



Question # 8 of 10 ( Start time: 04:57:18 PM ) Total Marks: 1
Consider the following relation vendor_order (vendor no, order no, vendor name, qty supplied , price/unit) where 'vendor no, order no' is PK. The second normal form relations are
Select correct option:


MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 64
sec(s)



Question # 9 of 10 ( Start time: 04:58:37 PM ) Total Marks: 1
A relation is said to be in BCNF when
Select correct option:


MC090409638 : Maryam Khalid



Quiz Start Time: 04:51 PM Time Left 41
sec(s)



Question # 10 of 10 ( Start time: 04:59:09 PM ) Total Marks: 1
Correct statement for creating table in Microsoft SQL server is.
Select correct option: