Database Management Systems Quiz

Your Name and Registration Number

Your Class

• II AIMLA A

• II BDA

• II CSE C

What is a primary key in a database?

• A key that can be null

• A key used for indexing

• A unique identifier for a record

• A key that can have duplicate values

Which of the following is a disadvantage of file processing systems?

• Data redundancy

• High data security

• Multi-user access support

• Efficient data handling

What does DBMS stand for?

• Database Management System

• Data Base Management Software

• Data Backup Management System

• Database Backup Software

Which of the following is an example of a NoSQL DBMS?

• MongoDB

• Oracle

• SQL Server

• MySQL

What is the purpose of normalization in databases?

• To enhance data security

• To reduce data duplication

• To improve data retrieval speed

• To increase data redundancy

Which data model organizes data in a tree-like structure?

• Relational Model

• Hierarchical Model

• Network Model

• Object-Oriented Model

What is the function of a foreign key?

• To link two tables together

• To uniquely identify a record

• To store metadata

• To enforce data integrity

Which of the following is NOT a type of DBMS?

• Relational DBMS

• Network DBMS

• Linear DBMS

• Hierarchical DBMS