Correct Answer is: Functional dependency

Database Management System - DBMS MCQ Multiple Choice Questions for Practice

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

Correct Answer is: Fourth normal form.

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

Correct Answer is: HAVING Clause

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

Correct Answer is: HAVING Clause

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

Correct Answer is: Normal forms.

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

Correct Answer is: Relational model

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

Correct Answer is: Like Predicate

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

Correct Answer is: Database state

Q: 16. An attribute is a(n):

Correct Answer is: column of a table

Q: 18. Which of the following is not a level of data abstraction?

Correct Answer is: Critical Level

Database Management System (DBMS) Multiple Choice Questions (MCQs) are essential practice tools for students and exam aspirants. These questions help reinforce your understanding of core DBMS concepts and prepare you for various assessments.

About Database Management System - DBMS MCQ Questions

Database Management System (DBMS) MCQs cover a wide range of topics, including data models, database design, SQL queries, transaction management, and security. These questions are designed to test your knowledge and ensure you can apply theoretical concepts in practical scenarios.

Why Practice Database Management System - DBMS Objective Questions?

Practicing DBMS MCQs offers several benefits. They help you prepare for school and college exams, competitive exams like GATE and UGC NET, and job interviews in the IT industry. Regular practice enhances your problem-solving skills, improves your speed and accuracy, and boosts your confidence in handling complex database-related questions.

Who Should Use These MCQs?

Students preparing for school or college exams
Competitive exam aspirants
Candidates preparing for interviews

Database Management System - DBMS MCQ Questions for Practice

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

Fourth
DKNF
BCNF
Third

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

Fourth normal form.
Second normal form.
Third normal form
Domain/key normal form.

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

FROM Clause
GROUP BY Clause
HAVING Clause
WHERE Clause

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

FROM Clause
GROUP BY Clause
HAVING Clause
WHERE Clause

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

Full Join
Join
Semi-Join
Inner Join

6. FD stands for:

Functional data
Functional dependency
Facilitate dependency
Facilitate data

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

Functional dependencies.
Normal forms.
Referential integrity constraints.
None of the above

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

Having
Select
Group-by
Order by

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

Hierarchical model
Network model
Relational model
None of these

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

In Predicate
Like Predicate
Null Predicate
Out Predicate

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

Index
Column
Constraint
Trigger

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

Index
View
Rule
Default

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

Initial state
Database state
Valid state
Empty state

14. ACID properties of transactions are

Isolation
Atomicity
Consistency
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.

isolation
atomicity
consistency
Durability

16. An attribute is a(n):

key of a table
two dimensional table
row of a table
column of a table

17. Retrieval of data is done by using a………………

Linked list
Stack
Query
All of these

18. Which of the following is not a level of data abstraction?

Logical Level
Physical Level
Critical Level
View Level

19. In which ways two tables may be related:

Many-many
One-one
One-many
All of these

20. A data dictionary is a repository that manages ………………

Metadata
Database
Memory
All of these

21. …………… database is used as template for all databases

Model
Create
Master
Tempdb

22. The DBMS utility..................... allows reconstructing the correct state of database from the backup and history of transactions.

Monitoring
Backup
Recovery
Data loading

23. The DBMSutility,………………allows to reconstruct the correct state of database from the backup and history of transactions.

Monitoring
Backup
Recovery
Data loading

24. An outstanding functionality of SQL is its support for automatic ………… to the target data.

Navigation
Programming
Functioning
Notification

25. A ……………… does not have a distinguishing attribute if its own and mostly are dependent entities, which are part of some another entity.

Non attributes entity
Weak entity
Strong entity
Dependent entity

26. Which is proper subset designed to support ‘views belonging to different classes of users in order to hid or protect information:

Non-schema
Schema
Subschema
None-subschema

27. For some relations, changing the data can have undesirable consequences called:

Normal forms.
Referential integrity constraints.
Modification anomalies.
Transitive dependencies.

28. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Normalization
Functional dependency
Database modeling
Decomposition

29. Which is the process of breaking a relation into multiple relations:

Normalization
Functional dependency
Database modeling
Decomposition

30. …………… is used to determine whether of a table contains duplicate rows.

Null predicate
Unique predicate
Like Predicate
In predicate