Michigan Database Administrator
Advanced Exam Questions and Correct
Answers (Verified Answers) Plus Rationales
2026 Q&A | Instant Download Pdf
1. Which SQL statement is used to remove a table and all its data
permanently?
A) DROP TABLE
B) DELETE TABLE
C) REMOVE TABLE
D) TRUNCATE TABLE
A) DROP TABLE
Rationale: DROP TABLE permanently deletes a table and its structure
from the database, whereas DELETE removes rows but keeps the table
structure.
2. In database normalization, which normal form eliminates
transitive dependencies?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
,C) 3NF
Rationale: Third Normal Form (3NF) removes transitive dependencies,
ensuring that non-key attributes depend only on the primary key.
3. What is the primary purpose of indexing in a database?
A) Increase storage space
B) Improve query performance
C) Backup the database
D) Normalize the tables
B) Improve query performance
Rationale: Indexing allows the database engine to locate and access
data faster, improving query response times.
4. Which SQL command is used to change existing data in a table?
A) MODIFY
B) UPDATE
C) ALTER
D) CHANGE
B) UPDATE
Rationale: UPDATE modifies existing rows in a table based on a
specified condition.
5. Which of the following is an example of a NoSQL database?
A) MySQL
B) PostgreSQL
C) MongoDB
D) Oracle
C) MongoDB
Rationale: MongoDB is a document-oriented NoSQL database, unlike
relational databases such as MySQL and PostgreSQL.
, 6. What does ACID stand for in database systems?
A) Atomicity, Consistency, Isolation, Durability
B) Access, Control, Integrity, Data
C) Analysis, Consistency, Indexing, Distribution
D) Atomicity, Concurrency, Isolation, Data
A) Atomicity, Consistency, Isolation, Durability
Rationale: ACID properties ensure reliable transaction processing in
relational databases.
7. Which SQL clause is used to filter records after aggregation?
A) WHERE
B) HAVING
C) GROUP BY
D) ORDER BY
B) HAVING
Rationale: HAVING filters the results of aggregate functions, while
WHERE filters rows before aggregation.
8. In database replication, which model allows changes to be made
at multiple nodes simultaneously?
A) Master-Slave
B) Single-Master
C) Multi-Master
D) Snapshot
C) Multi-Master
Rationale: Multi-Master replication allows multiple nodes to accept
updates and synchronize changes across the system.
9. Which isolation level allows dirty reads?
A) Read Uncommitted
B) Read Committed
, C) Repeatable Read
D) Serializable
A) Read Uncommitted
Rationale: Read Uncommitted allows transactions to read uncommitted
changes from other transactions, causing potential dirty reads.
10. What is the main advantage of partitioning a database
table?
A) Reduces data integrity
B) Enhances backup complexity
C) Improves query performance and manageability
D) Eliminates the need for indexes
C) Improves query performance and manageability
Rationale: Partitioning breaks large tables into smaller, manageable
pieces, improving performance and maintenance.
11. Which command is used to create a new database in SQL?
A) CREATE DATABASE
B) NEW DATABASE
C) INIT DATABASE
D) BUILD DATABASE
A) CREATE DATABASE
Rationale: CREATE DATABASE initializes a new database in the SQL
server environment.
12. In a relational database, which key uniquely identifies each
row in a table?
A) Foreign Key
B) Candidate Key
C) Primary Key
D) Composite Key
Advanced Exam Questions and Correct
Answers (Verified Answers) Plus Rationales
2026 Q&A | Instant Download Pdf
1. Which SQL statement is used to remove a table and all its data
permanently?
A) DROP TABLE
B) DELETE TABLE
C) REMOVE TABLE
D) TRUNCATE TABLE
A) DROP TABLE
Rationale: DROP TABLE permanently deletes a table and its structure
from the database, whereas DELETE removes rows but keeps the table
structure.
2. In database normalization, which normal form eliminates
transitive dependencies?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
,C) 3NF
Rationale: Third Normal Form (3NF) removes transitive dependencies,
ensuring that non-key attributes depend only on the primary key.
3. What is the primary purpose of indexing in a database?
A) Increase storage space
B) Improve query performance
C) Backup the database
D) Normalize the tables
B) Improve query performance
Rationale: Indexing allows the database engine to locate and access
data faster, improving query response times.
4. Which SQL command is used to change existing data in a table?
A) MODIFY
B) UPDATE
C) ALTER
D) CHANGE
B) UPDATE
Rationale: UPDATE modifies existing rows in a table based on a
specified condition.
5. Which of the following is an example of a NoSQL database?
A) MySQL
B) PostgreSQL
C) MongoDB
D) Oracle
C) MongoDB
Rationale: MongoDB is a document-oriented NoSQL database, unlike
relational databases such as MySQL and PostgreSQL.
, 6. What does ACID stand for in database systems?
A) Atomicity, Consistency, Isolation, Durability
B) Access, Control, Integrity, Data
C) Analysis, Consistency, Indexing, Distribution
D) Atomicity, Concurrency, Isolation, Data
A) Atomicity, Consistency, Isolation, Durability
Rationale: ACID properties ensure reliable transaction processing in
relational databases.
7. Which SQL clause is used to filter records after aggregation?
A) WHERE
B) HAVING
C) GROUP BY
D) ORDER BY
B) HAVING
Rationale: HAVING filters the results of aggregate functions, while
WHERE filters rows before aggregation.
8. In database replication, which model allows changes to be made
at multiple nodes simultaneously?
A) Master-Slave
B) Single-Master
C) Multi-Master
D) Snapshot
C) Multi-Master
Rationale: Multi-Master replication allows multiple nodes to accept
updates and synchronize changes across the system.
9. Which isolation level allows dirty reads?
A) Read Uncommitted
B) Read Committed
, C) Repeatable Read
D) Serializable
A) Read Uncommitted
Rationale: Read Uncommitted allows transactions to read uncommitted
changes from other transactions, causing potential dirty reads.
10. What is the main advantage of partitioning a database
table?
A) Reduces data integrity
B) Enhances backup complexity
C) Improves query performance and manageability
D) Eliminates the need for indexes
C) Improves query performance and manageability
Rationale: Partitioning breaks large tables into smaller, manageable
pieces, improving performance and maintenance.
11. Which command is used to create a new database in SQL?
A) CREATE DATABASE
B) NEW DATABASE
C) INIT DATABASE
D) BUILD DATABASE
A) CREATE DATABASE
Rationale: CREATE DATABASE initializes a new database in the SQL
server environment.
12. In a relational database, which key uniquely identifies each
row in a table?
A) Foreign Key
B) Candidate Key
C) Primary Key
D) Composite Key
