DBMS MCQ Test
100 DBMS multiple-choice questions with answers, from the ADCA syllabus. Instant score, full answer review, free and no signup.
Each attempt picks 25 questions at random from the 100 in this topic.
Score 50% or more? Get a certificate at 40% off
Finish any ADCA test on this site with a score of 50% or above and you can claim a course certificate from Alien Institute of Computer at a 40% discount. Your score appears on the result screen with a WhatsApp button that carries it across for you.
Ask about the certificateAll 100 DBMS questions with answers
1. What does DBMS stand for?
- A. Database Management System
- B. Data Management System
- C. Database Mainframe System
- D. Data Binary Management System
Answer: Database Management System
2. Which of the following is not a type of database?
- A. Relational
- B. Hierarchical
- C. Network
- D. String
Answer: String
3. In DBMS, what does SQL stand for?
- A. Secure Query Language
- B. Simple Query Language
- C. System Query Language
- D. Structured Query Language
Answer: Structured Query Language
4. Which type of key uniquely identifies each record in a table?
- A. Foreign Key
- B. Candidate Key
- C. Primary Key
- D. Composite Key
Answer: Primary Key
5. Which database model uses parent-child relationships?
- A. Relational
- B. Hierarchical
- C. Object-Oriented
- D. Network
Answer: Hierarchical
6. What is the purpose of a Foreign Key?
- A. To identify unique records
- B. To establish relationships between tables
- C. To index the table
- D. To sort data
Answer: To establish relationships between tables
7. Which of these operations is not part of CRUD?
- A. Create
- B. Update
- C. Remove
- D. Delete
Answer: Remove
8. What does DDL stand for?
- A. Database Design Language
- B. Data Directory Language
- C. Direct Database Language
- D. Data Definition Language
Answer: Data Definition Language
9. Which command is used to delete all records from a table?
- A. DELETE
- B. DROP
- C. REMOVE
- D. TRUNCATE
Answer: TRUNCATE
10. What is a tuple in DBMS?
- A. A column in a table
- B. A single row in a table
- C. A database schema
- D. A relationship between tables
Answer: A single row in a table
11. Which of the following is not a type of SQL statement?
- A. DCL
- B. DLL
- C. DML
- D. DQL
Answer: DLL
12. What does ACID stand for in databases?
- A. Atomicity, Consistency, Isolation, Durability
- B. Atomicity, Connectivity, Isolation, Data
- C. Array, Consistency, Isolation, Database
- D. Atomicity, Consistency, Interaction, Durability
Answer: Atomicity, Consistency, Isolation, Durability
13. In which of these models is data organized in a tree structure?
- A. Relational
- B. Object-Oriented
- C. Hierarchical
- D. Entity-Relationship
Answer: Hierarchical
14. Which SQL keyword is used to sort data in ascending or descending order?
- A. SORT
- B. ORDER BY
- C. ARRANGE
- D. GROUP BY
Answer: ORDER BY
15. Which SQL clause is used to filter records?
- A. FILTER
- B. LIMIT
- C. WHERE
- D. SORT
Answer: WHERE
16. What is the purpose of normalization in databases?
- A. To increase redundancy
- B. To create backup
- C. To optimize queries
- D. To reduce redundancy
Answer: To reduce redundancy
17. Which of the following normal forms aims to eliminate transitive dependencies?
- A. 1NF
- B. 2NF
- C. 3NF
- D. BCNF
Answer: 3NF
18. What does the SQL command 'JOIN' do?
- A. Combines data from multiple tables
- B. Deletes data from a table
- C. Creates a new database
- D. Sorts data in a table
Answer: Combines data from multiple tables
19. Which type of join returns only matching rows from both tables?
- A. LEFT JOIN
- B. RIGHT JOIN
- C. INNER JOIN
- D. OUTER JOIN
Answer: INNER JOIN
20. Which SQL function is used to get the current date?
- A. NOW()
- B. GETDATE()
- C. CURRENT_DATE
- D. DATE()
Answer: CURRENT_DATE
21. What does the UNIQUE constraint ensure?
- A. All values are the same
- B. All values are indexed
- C. All values are foreign keys
- D. All values are different
Answer: All values are different
22. Which SQL command is used to create a new table?
- A. NEW TABLE
- B. INSERT TABLE
- C. MAKE TABLE
- D. CREATE TABLE
Answer: CREATE TABLE
23. Which term is used for columns in a database table?
- A. Rows
- B. Fields
- C. Entries
- D. Attributes
Answer: Attributes
24. What is an index used for in a database?
- A. To delete data
- B. To speed up retrieval
- C. To manage transactions
- D. To perform joins
Answer: To speed up retrieval
25. Which of the following is a popular open-source RDBMS?
- A. MS Access
- B. Oracle
- C. MySQL
- D. Sybase
Answer: MySQL
26. Which of the following is an example of a database management system?
- A. Oracle
- B. Excel
- C. Notepad
- D. PowerPoint
Answer: Oracle
27. Which command is used to permanently remove a table from a database?
- A. DELETE
- B. DROP
- C. REMOVE
- D. CLEAR
Answer: DROP
28. Which SQL clause is used to limit the number of records returned?
- A. LIMIT
- B. REDUCE
- C. FILTER
- D. SORT
Answer: LIMIT
29. Which command is used to add new data into a database table?
- A. UPDATE
- B. INSERT
- C. ADD
- D. SELECT
Answer: INSERT
30. In SQL, which clause is used to group rows that have the same values?
- A. ORDER BY
- B. SORT
- C. GROUP BY
- D. JOIN
Answer: GROUP BY
31. Which of these is a NoSQL database?
- A. Oracle
- B. PostgreSQL
- C. SQL Server
- D. MongoDB
Answer: MongoDB
32. What does 'DDL' stand for?
- A. Data Description Language
- B. Data Definition Language
- C. Data Delete Language
- D. Data Defining Language
Answer: Data Definition Language
33. Which SQL command is used to modify existing data in a table?
- A. INSERT
- B. MODIFY
- C. UPDATE
- D. ALTER
Answer: UPDATE
34. Which command is used to undo a transaction in SQL?
- A. UNDO
- B. ROLLBACK
- C. CANCEL
- D. DELETE
Answer: ROLLBACK
35. What is a schema in a database?
- A. A query language
- B. A command in SQL
- C. The overall structure and design of the database
- D. A type of data
Answer: The overall structure and design of the database
36. In a relational database, what does each table represent?
- A. An entity
- B. A function
- C. A schema
- D. A relationship
Answer: An entity
37. What is a record in a database?
- A. A column in a table
- B. A row in a table
- C. A table
- D. A database
Answer: A row in a table
38. Which command is used to create a new database in SQL?
- A. NEW DATABASE
- B. MAKE DATABASE
- C. CREATE DATABASE
- D. ADD DATABASE
Answer: CREATE DATABASE
39. What is a transaction in the context of DBMS?
- A. A type of database
- B. A sequence of operations
- C. A backup process
- D. A form of normalization
Answer: A sequence of operations
40. Which type of SQL command is SELECT?
- A. DML
- B. DQL
- C. DDL
- D. DCL
Answer: DQL
41. Which type of database uses tables, rows, and columns?
- A. Hierarchical
- B. Object-oriented
- C. Relational
- D. Network
Answer: Relational
42. Which command in SQL is used to delete a database?
- A. REMOVE DATABASE
- B. DROP DATABASE
- C. DELETE DATABASE
- D. CLEAR DATABASE
Answer: DROP DATABASE
43. Which of these is a characteristic of NoSQL databases?
- A. Tabular structure
- B. Fixed schema
- C. SQL-based
- D. Schema-less
Answer: Schema-less
44. In SQL, what does the HAVING clause do?
- A. Filters groups
- B. Filters individual rows
- C. Sorts data
- D. Limits data
Answer: Filters groups
45. Which command is used to grant privileges in SQL?
- A. ALLOW
- B. GRANT
- C. PERMIT
- D. GIVE
Answer: GRANT
46. Which keyword is used to remove duplicate records?
- A. UNIQUE
- B. REMOVE
- C. DISTINCT
- D. DELETE
Answer: DISTINCT
47. Which function returns the total number of rows?
- A. COUNT()
- B. SUM()
- C. TOTAL()
- D. NUMBER()
Answer: COUNT()
48. What is a primary function of a DBMS?
- A. Image processing
- B. Video streaming
- C. Data encryption only
- D. Data storage and retrieval
Answer: Data storage and retrieval
49. Which of these is a property of relational databases?
- A. Hierarchical structure
- B. Relationships between tables
- C. Schema-less structure
- D. Data redundancy
Answer: Relationships between tables
50. In a relational model, rows are also called?
- A. Attributes
- B. Cells
- C. Entities
- D. Tuples
Answer: Tuples
51. Which SQL keyword is used to add constraints?
- A. LIMIT
- B. CONDITION
- C. CONSTRAINT
- D. CHECK
Answer: CONSTRAINT
52. What is the use of the SQL 'ALTER TABLE' command?
- A. To modify a table structure
- B. To add data
- C. To delete records
- D. To backup data
Answer: To modify a table structure
53. What is a database?
- A. A type of network
- B. A programming language
- C. An operating system
- D. A collection of data
Answer: A collection of data
54. Which key is used to uniquely identify each record in a table?
- A. Secondary Key
- B. Alternate Key
- C. Primary Key
- D. Composite Key
Answer: Primary Key
55. Which SQL keyword is used to remove records from a table?
- A. REMOVE
- B. DELETE
- C. CLEAR
- D. DROP
Answer: DELETE
56. What does DCL stand for in DBMS?
- A. Database Control Language
- B. Data Control Language
- C. Data Collection Language
- D. Direct Control Language
Answer: Data Control Language
57. Which language is used to interact with a database?
- A. HTML
- B. CSS
- C. JavaScript
- D. SQL
Answer: SQL
58. Which SQL keyword is used to change data in a table?
- A. MODIFY
- B. CHANGE
- C. ALTER
- D. UPDATE
Answer: UPDATE
59. In a DBMS, what is a view?
- A. A backup
- B. A virtual table
- C. A physical table
- D. A schema
Answer: A virtual table
60. What type of join returns all records from the left table and matching records from the right?
- A. RIGHT JOIN
- B. INNER JOIN
- C. LEFT JOIN
- D. OUTER JOIN
Answer: LEFT JOIN
61. Which of the following is a function of a database administrator?
- A. Software development
- B. Data backup
- C. Network design
- D. Hardware maintenance
Answer: Data backup
62. Which SQL statement is used to fetch data from a database?
- A. FETCH
- B. SELECT
- C. GET
- D. RETRIEVE
Answer: SELECT
63. In relational databases, what is a foreign key?
- A. An alternative key
- B. A unique key
- C. A composite key
- D. A reference to a primary key
Answer: A reference to a primary key
64. What does the SQL command COMMIT do?
- A. Saves transaction changes
- B. Reverts changes
- C. Deletes records
- D. Sorts data
Answer: Saves transaction changes
65. Which of these is used to describe the structure of a database?
- A. Tuple
- B. Schema
- C. Key
- D. Attribute
Answer: Schema
66. What does RDBMS stand for?
- A. Relational Database Management System
- B. Random Database Management System
- C. Remote Database Management System
- D. Rapid Database Management System
Answer: Relational Database Management System
67. What does SQL 'GROUP BY' clause do?
- A. Sorts data
- B. Deletes records
- C. Groups rows with similar values
- D. Updates records
Answer: Groups rows with similar values
68. Which SQL keyword is used to retrieve unique records?
- A. DISTINCT
- B. UNIQUE
- C. SINGLE
- D. LIMIT
Answer: DISTINCT
69. What is the purpose of the 'ORDER BY' clause?
- A. To sort results
- B. To delete records
- C. To join tables
- D. To filter records
Answer: To sort results
70. Which of the following is a characteristic of a primary key?
- A. It can be null
- B. It is redundant
- C. It is optional
- D. It is unique
Answer: It is unique
71. Which constraint ensures that no duplicate values are inserted in a column?
- A. DEFAULT
- B. UNIQUE
- C. FOREIGN KEY
- D. PRIMARY KEY
Answer: UNIQUE
72. In a database, what is a 'NULL' value?
- A. A zero value
- B. A duplicate value
- C. A missing or undefined value
- D. An error value
Answer: A missing or undefined value
73. Which command in SQL removes all rows without deleting the table structure?
- A. DELETE
- B. TRUNCATE
- C. DROP
- D. REMOVE
Answer: TRUNCATE
74. What does 'IS NOT NULL' check in SQL?
- A. That a column has values
- B. That a column is empty
- C. That a column has a default value
- D. That a column has zero
Answer: That a column has values
75. What is a database transaction?
- A. A backup process
- B. An SQL command
- C. A sequence of operations treated as a single unit
- D. A type of table
Answer: A sequence of operations treated as a single unit
76. Which SQL statement is used to delete a table structure?
- A. DELETE TABLE
- B. CLEAR TABLE
- C. DROP TABLE
- D. TRUNCATE TABLE
Answer: DROP TABLE
77. In a relational database, what is an entity?
- A. A distinct object
- B. A type of database
- C. A SQL command
- D. A form of schema
Answer: A distinct object
78. Which of the following is NOT a NoSQL database?
- A. MongoDB
- B. Cassandra
- C. MySQL
- D. CouchDB
Answer: MySQL
79. What does the term 'redundancy' mean in a database?
- A. Unique data
- B. Duplicate data
- C. Indexed data
- D. Primary data
Answer: Duplicate data
80. Which of these is a data manipulation language command?
- A. CREATE
- B. ALTER
- C. GRANT
- D. INSERT
Answer: INSERT
81. What is data integrity?
- A. Speed of retrieval
- B. Accuracy and consistency of data
- C. Redundancy of data
- D. Size of data
Answer: Accuracy and consistency of data
82. What is the purpose of an ER diagram?
- A. To execute SQL commands
- B. To program in SQL
- C. To visually represent database structure
- D. To backup databases
Answer: To visually represent database structure
83. Which of these is a common NoSQL database model?
- A. Tuple
- B. Entity
- C. Table
- D. Document
Answer: Document
84. What is the purpose of a composite key?
- A. To create a backup
- B. To speed up queries
- C. To manage transactions
- D. To uniquely identify records using multiple columns
Answer: To uniquely identify records using multiple columns
85. Which type of join returns all rows when there is a match in either table?
- A. FULL OUTER JOIN
- B. INNER JOIN
- C. LEFT JOIN
- D. RIGHT JOIN
Answer: FULL OUTER JOIN
86. What does the SQL constraint CHECK do?
- A. Sets a default value
- B. Ensures a condition is true
- C. Ensures uniqueness
- D. Creates a relationship
Answer: Ensures a condition is true
87. What is a stored procedure?
- A. A temporary table
- B. An SQL view
- C. A precompiled set of SQL commands
- D. A join operation
Answer: A precompiled set of SQL commands
88. Which SQL function finds the minimum value?
- A. LOWEST()
- B. MIN()
- C. SMALL()
- D. LIMIT()
Answer: MIN()
89. Which SQL clause is used to rename a table?
- A. MODIFY
- B. RENAME
- C. CHANGE
- D. ALTER
Answer: RENAME
90. What is a clustered index?
- A. An index on foreign key
- B. A temporary index
- C. A primary index on a table
- D. A unique index only
Answer: A primary index on a table
91. What is an attribute in a database?
- A. A row in a table
- B. A column in a table
- C. A table itself
- D. A constraint
Answer: A column in a table
92. Which constraint restricts values in a column based on a condition?
- A. CHECK
- B. UNIQUE
- C. PRIMARY KEY
- D. NOT NULL
Answer: CHECK
93. Which SQL function is used to find the average of a column?
- A. SUM()
- B. MEAN()
- C. COUNT()
- D. AVG()
Answer: AVG()
94. What is the purpose of the 'UNION' operator in SQL?
- A. Updates records
- B. Combines results of two SELECT statements
- C. Deletes records
- D. Sorts records
Answer: Combines results of two SELECT statements
95. Which command in SQL creates an index?
- A. CREATE INDEX
- B. INDEX CREATE
- C. ADD INDEX
- D. MAKE INDEX
Answer: CREATE INDEX
96. Which of the following is a distributed NoSQL database?
- A. MySQL
- B. Oracle
- C. Cassandra
- D. SQL Server
Answer: Cassandra
97. What is the purpose of the 'EXISTS' clause in SQL?
- A. Checks if a subquery returns any rows
- B. Sorts records
- C. Deletes records
- D. Joins tables
Answer: Checks if a subquery returns any rows
98. Which SQL keyword is used to combine results from multiple queries?
- A. JOIN
- B. MERGE
- C. UNION
- D. LINK
Answer: UNION
99. Which SQL function counts the number of non-null rows?
- A. COUNT()
- B. SUM()
- C. LIST()
- D. TOTAL()
Answer: COUNT()
100. What is an E-R model?
- A. Entity-Relational model
- B. Entry-Relationship model
- C. Entity-Referential model
- D. Entity-Relationship model
Answer: Entity-Relationship model
Frequently asked questions
How many DBMS questions are in this test?
This page has 100 DBMS MCQs with answers. Each attempt picks 25 of them at random.
Is the DBMS test free?
Yes — it is free, needs no signup, and you can retake it as many times as you like.
Can I get a certificate for this test?
Score 50% or more and you can claim a certificate from Alien Institute of Computer at 40% off. The WhatsApp button appears on your result screen.