Logical Database Design MCQ

Test your knowledge with important Logical Database Design MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Logical Database Design MCQs on Bissoy. Bissoy App

• Normalization is a formal process for deciding which attributes should be grouped together in a relation.
  ক

  True

  খ

  False
• A null value is assigned when no other value applies.
  ক

  True

  খ

  False
• An enterprise key is a primary key whose value is unique for a given relation.
  ক

  True

  খ

  False
• When mapping a regular entity into a relation which of the following is true?
  ক

  One relation is created.

  খ

  Two relations are created.

  গ

  Three relations are created.

  ঘ

  Four relations are created.
• When mapping a ternary relationship with an associative entity into a relation which of the following is true?
  ক

  One relation is created.

  খ

  Two relations are created.

  গ

  Three relations are created.

  ঘ

  Four relations are created.
• A relation has which of the following properties?
  ক

  Each row is not unique.

  খ

  Attributes can have the same name within a given table.

  গ

  Each relation has a unique name.

  ঘ

  The order of the columns is significant.
• When mapping a binary many-to-many relationship into a relation which of the following is true?
  ক

  One relation is created.

  খ

  Two relations are created.

  গ

  Three relations are created.

  ঘ

  Four relations are created.
• A primary key is which of the following?
  ক

  Any attribute

  খ

  An attribute that uniquely identifies each row

  গ

  An attribute that uniquely identifies each column

  ঘ

  A derived attribute
• If no multivalued attributes exist in a relation, then the relation is in what normal form?
  ক

  First normal form

  খ

  Second normal form

  গ

  Third normal form

  ঘ

  Fourth normal form
• When mapping a multivalued attribute into a relation which of the following is true?
  ক

  One relation is created.

  খ

  Two relations are created.

  গ

  Three relations are created.

  ঘ

  Four relations are created.
• A foreign key is which of the following?
  ক

  Any attribute

  খ

  The same thing as a primary key

  গ

  An attribute that serves as the primary key of another relation

  ঘ

  An attribute that serves no purpose
• When mapping a many-to-many unary relationship into a relation which of the following is true?
  ক

  One relation is created.

  খ

  Two relations are created.

  গ

  Three relations are created.

  ঘ

  Four relations are created.