CS403 Database Management Systems Quiz 2 Fall 2012

Another Quiz

CS-403 2nd Quiz

Question # 1 of 5 ( Start time: 06:13:09 PM )  Total Marks: 1
Which of the following constraints enforces entity integrity?
Select correct option:

 PRIMARY KEY (Correct)

Question # 2 of 5 ( Start time: 06:14:37 PM )  Total Marks: 1
Which of the following is a feature of CHECK constraint?
Select correct option:

 limit the values that can be placed in a column. (Correct)
used to enforce referential integrity.
enforces the uniqueness of the values in a set of columns.
is a unique identifier for a row within a database table.

Question # 3 of 5 ( Start time: 06:16:08 PM )  Total Marks: 1
In “One to Many” cardinality one instance of a relation is mapped with
Select correct option:

 many instances of second entity type (Correct)
One instance of second entity type
Primary key of 2 relations
none of above

Question # 4 of 5 ( Start time: 06:17:21 PM )  Total Marks: 1
Binary relationships are those, which are established between
Select correct option:

One entity type
 Two entity type (Correct)
Three entity type
Unlimited entities

Question # 5 of 5 ( Start time: 06:18:04 PM )  Total Marks: 1
in “many to many relationship” one instance of first entity can be mapped with many instances of second entity
Select correct option:

 true (Correct)