Database Management System - DBMS MCQ Questions and Answers Quiz

81. Which key is referencing a primary key in a table:

  1. Foreign key
  2. Primary key
  3. Candidate key
  4. All of these

82. The primary key is selected from the:

  1. Foreign keys
  2. Composite keys
  3. Candidate keys
  4. Determinants

83. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ............... Is needed

  1. Fourth
  2. DKNF
  3. BCNF
  4. Third

84. If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ----------------- is needed

  1. Fourth
  2. DKNF
  3. BCNF
  4. Third

85. A relation is in this form if it is in BCNF and has no multivalued dependencies:

  1. Fourth normal form.
  2. Second normal form.
  3. Third normal form
  4. Domain/key normal form.

86. ……………..specifies a search condition for a group or an aggregate.

  1. FROM Clause
  2. GROUP BY Clause
  3. HAVING Clause
  4. WHERE Clause

87. ……………..specifies a search condition for a group or an aggregate.

  1. FROM Clause
  2. GROUP BY Clause
  3. HAVING Clause
  4. WHERE Clause

88. ………………….operator is basically a join followed by a project on the attributes of first relation.

  1. Full Join
  2. Join
  3. Semi-Join
  4. Inner Join

89. FD stands for:

  1. Functional data
  2. Functional dependency
  3. Facilitate dependency
  4. Facilitate data

90. The different classes of relations created by the technique for preventing modification anomalies are called:

  1. Functional dependencies.
  2. Normal forms.
  3. Referential integrity constraints.
  4. None of the above
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Question and Answer