Database Management System - DBMS MCQ Questions and Answers for Practice

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

11. ……………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

1. Index
2. Column
3. Constraint
4. Trigger

12. ……………….contains information that defines valid values that are stored in a column or data type.

1. Index
2. View
3. Rule
4. Default

13. The data in the database at a particular moment in time is called a ………………

1. Initial state
2. Database state
3. Valid state
4. Empty state

14. ACID properties of transactions are

1. Isolation
2. Atomicity
3. Consistency
4. Durability

15. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.

1. isolation
2. atomicity
3. consistency
4. Durability