Database Management System - DBMS MCQ Quiz - Multiple Choice Questions & Answers

1. 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

2. 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.

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

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

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

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

5. ………………….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

6. FD stands for:

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

7. 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

8. ……………… clause is an additional filter that is applied to the result.

1. Having
2. Select
3. Group-by
4. Order by

9. In which model of database data is stored in tables:

1. Hierarchical model
2. Network model
3. Relational model
4. None of these

10. The .................... is essentially used to search for patterns in target string.

1. In Predicate
2. Like Predicate
3. Null Predicate
4. Out Predicate