ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the properties that guarantee reliable processing of database transactions.
Correct Answer: A — Atomicity, Consistency, Isolation, Durability
Q. What is the main purpose of concurrency control in a DBMS?
A.To prevent data loss
B.To ensure data consistency
C.To speed up data retrieval
D.To manage user permissions
Solution
The main purpose of concurrency control in a DBMS is to ensure data consistency when multiple transactions are executed simultaneously.
Correct Answer: B — To ensure data consistency
Q. Which of the following is a characteristic of a relational database?
A.Data is stored in tables
B.Data is stored in files
C.Data is stored in objects
D.Data is stored in arrays
Solution
A characteristic of a relational database is that data is stored in tables.
Correct Answer: A — Data is stored in tables
Q. Which of the following is NOT a type of normalization?
A.First Normal Form
B.Second Normal Form
C.Third Normal Form
D.Fourth Normal Form
Solution
Fourth Normal Form is a valid type of normalization; however, the question is misleading as all options are types of normalization.
Correct Answer: D — Fourth Normal Form
Q. Which SQL statement is used to create an index?
A.CREATE INDEX
B.ADD INDEX
C.NEW INDEX
D.INDEX CREATE
Solution
The SQL statement used to create an index is 'CREATE INDEX'.
