CS403 Quiz No.2 Shared by Raheela

Question # 1 of 10 ( Start time: 05:29:03 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 # 2 of 10 ( Start time: 05:29:29 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 # 3 of 10 ( Start time: 05:30:10 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 # 4 of 10 ( Start time: 05:31:09 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  ok


Question # 5 of 10 ( Start time: 05:31:56 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
Hierarchal
Object oriented
Any model can be used  ok


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


Question # 7 of 10 ( Start time: 05:32:42 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:33:13 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 # 9 of 10 ( Start time: 05:33:48 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 # 10 of 10 ( Start time: 05:34:41 PM ) Total Marks: 1
Identify the INCORRECT statement.
Select correct option:
Relational data model is based on mathematics
In relational data model there is no manipulation language defined
Relational data model is simple  ok
We can test mathematically anything before using it in RDM and it will work fine