CS403 Quiz No.2 Shared by Annie

Question # 2 of 10 ( Start time: 05:07:20 PM ) Total Marks: 1
Which of the following tool is used to design conceptual database design?
Select correct option:
SQL
MS Access
Oracle
This model is independent of any tool  ok


Question # 3 of 10 ( Start time: 05:07:20 PM ) Total Marks: 1
in “One to One Relationship” One instance of first entity type is mapped with two instances of second entity type
Select correct option:
true
false  ok


Question # 4 of 10 ( Start time: 05:07:20 PM ) Total Marks: 1
Unary operations involves
Select correct option:
Only one relation  ok
Only two relations
More than two relations
Not more than five relations


Question # 5 of 10 ( Start time: 05:07:20 PM ) Total Marks: 1
Which of the following is true regarding foreign keys?
Select correct option:
There can only be one foreign key in a relation  ok
There can be as many foreign keys as needed
Foreign key is not a super key
Each table in database must have a foreign key


Question # 6 of 10 ( Start time: 05:07:20 PM ) Total Marks: 1
Relational Calculus is a _____________ relational data manipulation language.
Select correct option:
Procedural, Informal
Non-Procedural, Informal
Procedural, Formal
Non-Procedural, Formal  ok


Question # 7 of 10 ( Start time: 05:07:20 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 # 8 of 10 ( Start time: 05:07:20 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  ok
false


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


Question # 10 of 10 ( Start time: 05:07:20 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