Reduction to Relational Schema MCQ

Test your knowledge with important Reduction to Relational Schema MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Reduction to Relational Schema MCQs at Bissoy

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

  Alphabetical order

  খ

  The data in the attribute

  গ

  Cardinality ratio

  ঘ

  None of the mentioned
• 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
  ক

  Both the statements are true

  খ

  Both the statements are false

  গ

  Statement 1 is true and Statement 2 is false

  ঘ

  Statement 2 is true and statement 1 is false
• State true or false: The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.
  ক

  True

  খ

  False
• For a n-ary relationship set without arrows, the ________ of the participating entity sets becomes the prime attribute
  ক

  Intersection of primary keys

  খ

  Primary key of either one

  গ

  Union of primary keys

  ঘ

  Primary key on the many side
• For a binary one to one relationship, the ________ of the participating entity sets becomes the prime attribute
  ক

  Intersection of primary keys

  খ

  Primary key of either one

  গ

  Union of primary keys

  ঘ

  Primary key on the many side
• For a binary many to many relationship, the ________ of the participating entity sets becomes the prime attribute
  ক

  Intersection of primary keys

  খ

  Primary key of either one

  গ

  Union of primary keys

  ঘ

  Primary key on the many side
• The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______
  ক

  Discriminator of the weak entity set

  খ

  Foreign key

  গ

  Primary key of all the other entity sets

  ঘ

  All the attributes of the weak entity set
• State true or false: Derived attributes cannot be directly represented in the relational data model
  ক

  True

  খ

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

  First attribute

  খ

  Primary key

  গ

  Foreign key

  ঘ

  None of the mentioned