Explore topic-wise MCQs in Rdbms.

This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following can affect the placement of the relationship attributes?

A. tAlphabetical order
B. tThe data in the attribute
C. tCardinality ratio
D. tNone of the mentioned
Answer» D. tNone of the mentioned
Discussion
2.

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. tBoth the statements are true
B. tBoth the statements are false
C. tStatement 1 is true and Statement 2 is false
D. tStatement 2 is true and statement 1 is false
Answer» D. tStatement 2 is true and statement 1 is false
Discussion
3.

State true or false: The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.

A. tTrue
B. tFalse
Answer» B. tFalse
Discussion
4.

For a binary one to one relationship, the ________ of the participating entity sets becomes the prime attribute

A. tIntersection of primary keys
B. tPrimary key of either one
C. tUnion of primary keys
D. tPrimary key on the many side
Answer» C. tUnion of primary keys
Discussion
5.

For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema

A. tFirst attribute
B. tPrimary key
C. tForeign key
D. tNone of the mentioned
Answer» C. tForeign key
Discussion