RDBMS Questions and Answers – Reduction to Relational Schema

This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Reduction to Relational Schema”.

1. For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema
a) First attribute
b) Primary key
c) Foreign key
d) None of the mentioned
View Answer

2. State true or false: Derived attributes cannot be directly represented in the relational data model
a) True
b) False
View Answer

3. The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______
a) Discriminator of the weak entity set
b) Foreign key
c) Primary key of all the other entity sets
d) All the attributes of the weak entity set
View Answer

4. For a binary many to many relationship, the ________ of the participating entity sets becomes the prime attribute
a) Intersection of primary keys
b) Primary key of either one
c) Union of primary keys
d) Primary key on the many side
View Answer

5. For a binary one to one relationship, the ________ of the participating entity sets becomes the prime attribute
a) Intersection of primary keys
b) Primary key of either one
c) Union of primary keys
d) Primary key on the many side
View Answer

6. For a binary many to many relationship, the ________ of the participating entity sets becomes the prime attribute
a) Intersection of primary keys
b) Primary key of either one
c) Union of primary keys
d) Primary key on the many side
View Answer

7. For a n-ary relationship set without arrows, the ________ of the participating entity sets becomes the prime attribute
a) Intersection of primary keys
b) Primary key of either one
c) Union of primary keys
d) Primary key on the many side
View Answer

8. State true or false: The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.
a) True
b) False
View Answer

9. Statement 1: We can create foreign key constraints on relational schema derived from ER diagram
Statement 2: Relational schema cannot be derived from an ER diagram
a) Both the statements are true
b) Both the statements are false
c) Statement 1 is true and Statement 2 is false
d) Statement 2 is true and statement 1 is false
View Answer

10. Which of the following can affect the placement of the relationship attributes?
a) Alphabetical order
b) The data in the attribute
c) Cardinality ratio
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.