CS403 Quiz No.2 Shared by Amir Haider

Question # 1 of 10 ( Start time: 05:22:17 PM ) Total Marks: 1
Math relations are same as database relations
Select correct option:
True  ok
False


Question # 2 of 10 ( Start time: 05:22:41 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
false  ok


Question # 3 of 10 ( Start time: 05:23:14 PM ) Total Marks: 1
“Select” and “project” are the examples of
Select correct option:
Unary operations  ok
Binary operations
Ternary operations
All of above


Question # 4 of 10 ( Start time: 05:23:56 PM ) Total Marks: 1
Identify the INCORRECT statement.
Select correct option:
Relational data model is based on mathematics  ok
In relational data model there is no manipulation language defined
Relational data model is simple
We can test mathematically anything before using it in RDM and it will work fine


Question # 5 of 10 ( Start time: 05:24:33 PM ) Total Marks: 1
Which of the following constraint is included in the definition of the table?
Select correct option:
Default value
Foreign Key
Null
Domain 


Question # 6 of 10 ( Start time: 05:25:45 PM ) Total Marks: 1
_______ is same as Equi-Join with a slight difference.
Select correct option:
Natural Join  ok
Semi Join
Outer Join
Theta Join


Question # 7 of 10 ( Start time: 05:26:17 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  ok
One instance of second entity type
Primary key of 2 relations
none of above


Question # 8 of 10 ( Start time: 05:26:45 PM ) Total Marks: 1
Select the most appropriate statement. Which of the following data model is used to design logical database design?
Select correct option:
Relational  ok
Hierarchal
Object oriented
Any model can be used


Question # 9 of 10 ( Start time: 05:27:35 PM ) Total Marks: 1
Binary relationships are those, which are established between
Select correct option:
One entity type
Two entity type
Three entity type
Unlimited entities


Question # 10 of 10 ( Start time: 05:27:35 PM ) Total Marks: 1
Which database design represents the structure of the database?
Select correct option:
Conceptual
Internal
External
Logical  ok