DBMS Aptitude Test - 25 MCQ Questions with Answers

This post presents a DBMS (Database Management System) aptitude test with 25 multiple-choice questions for beginners. These beginner-level MCQ questions cover the fundamentals of DBMS.

1. What does DBMS stand for?

a) Database Management Service

b) Database Maintenance System

c) Database Management System

d) Data Backup Management System

2. Which of the following is not a function of a DBMS?

a) Data redundancy control

b) Data manipulation

c) Networking setup

d) Data security management

3. What is a primary key?

a) A key used to open the database

b) The main keyboard shortcut for accessing database records

c) A unique identifier for each record in a table

d) The most important user of a database

4. Which type of relationship is represented by a many-to-many relationship in databases?

a) One table is related to many tables

b) Many records in one table relate to many records in another table

c) Each record in one table relates to multiple records in another table

d) A record in one table relates to only one record in another table

5. What is normalization in DBMS?

a) Adjusting the database size to save disk space

b) Organizing data to reduce data redundancy and improve data integrity

c) Increasing the number of redundant records to speed up the query process

d) Simplifying the user interface of the database management system

6. Which SQL statement removes a table from a database?

a) REMOVE TABLE

b) DELETE TABLE

c) DROP TABLE

d) EXTRACT TABLE

7. What is a foreign key?

a) A key that uniquely identifies each row in another table

b) A primary key of one table used as a reference in another table

c) A key used to unlock encrypted database data

d) A key that prevents access to data by unauthorized users

8. What is the purpose of an index in a DBMS?

a) To limit data access speeds

b) To create a physical storage for a database

c) To enhance the performance of database queries

d) To increase data redundancy

9. What is the ACID principle in databases?

a) Algorithm, Calculation, Isolation, and Durability

b) Atomicity, Consistency, Isolation, Durability

c) Association, Consistency, Isolation, and Data

d) Atomicity, Connection, Isolation, Durability

10. What is a deadlock in DBMS?

a) When the system crashes

b) When two or more transactions hold locks that prevent the others from accessing the database

c) When data is corrupted in the database

d) When there is insufficient storage in the database

11. Which data model uses tables, rows, and columns to represent data?

a) Hierarchical model

b) Network model

c) Relational model

d) Object-oriented model

12. What does DDL stand for in DBMS?

a) Data Derivation Language

b) Data Duplication Language

c) Data Definition Language

d) Database Design Language

13. What type of integrity constraint ensures that all foreign key values point to existing rows?

a) Referential integrity

b) User-defined integrity

c) Domain integrity

d) Structural integrity

14. Which DBMS type is best suited for handling complex data relationships and dynamic schema?

a) Relational DBMS

b) Hierarchical DBMS

c) Network DBMS

d) NoSQL DBMS

15. What is the function of the SQL HAVING clause?

a) To specify which columns to retrieve

b) To define conditions on groups created by the GROUP BY clause

c) To restrict the number of rows returned

d) To join tables

16. What is the transaction control language used for?

a) Defining database schema

b) Manipulating the data in the database

c) Managing database security

d) Managing transaction properties

17. What is the purpose of a schema in a database?

a) To define views and relationships

b) To describe the logical structure of the database

c) To provide physical storage to the database

d) To optimize the database speed

18. Which type of database is designed to handle large scale data distribution and parallel processing?

a) XML databases

b) Desktop databases

c) Distributed databases

d) Personal databases

19. What is the primary difference between WHERE and HAVING clauses?

a) WHERE filters rows, while HAVING filters columns

b) WHERE is used before grouping, and HAVING is used after grouping

c) WHERE is only used in SELECT statements, while HAVING is used in all statements

d) There is no difference

20. What does the JOIN statement do in SQL?

a) Combines columns from one or more tables based on related columns between them

b) Lists all rows in a table

c) Deletes matching rows between tables

d) Updates columns in a table

21. How can data redundancy be reduced in a database?

a) By increasing the number of duplicate records

b) By ensuring each piece of data is stored only once

c) By removing all primary keys

d) By using only one table

22. What is data integrity?

a) Maintaining and assuring the accuracy and consistency of data over its lifecycle

b) Ensuring that data is not accessible by unauthorized users

c) Backing up data regularly

d) Increasing the storage capacity of the database

23. What is a view in SQL?

a) A virtual table based on the result-set of an SQL statement

b) A physical table saved in the database

c) A command used to see all the data in a table

d) A type of user interface in database management systems

24. What is a stored procedure?

a) A set of SQL commands that can be reused later

b) A method to store data in the database

c) A special kind of database model

d) A way to physically store database files

25. Which statement is true about NoSQL databases?

a) They use strict schemas

b) They are primarily used for complex queries

c) They are designed to expand horizontally

d) They do not allow data storage across multiple systems