SQL Indexes & Transactions Quiz

Indexes and transactions are vital components of database optimization and transaction management in SQL. In this quiz, you'll delve into the world of SQL indexes, including understanding their types (such as B-tree, Hash, and Bitmap indexes) and their significance in enhancing query performance. Additionally, you'll explore transactions, learning about their role in maintaining data integrity and ensuring ACID properties (Atomicity, Consistency, Isolation, Durability).

Question 1

What is an index in SQL?

• A data structure that stores values in sorted order for fast retrieval

• A temporary table used for intermediate data processing

• A constraint that ensures data integrity

• A function that calculates aggregate values

Question 2

Which SQL statement is used to create an index?

• CREATE INDEX

• ADD INDEX

• INDEX TABLE

• SET INDEX

Question 3

What is the purpose of an index in SQL?

• To enforce data integrity constraints

• To store intermediate query results

• To improve the speed of data retrieval operations

• To perform calculations on aggregate data

Question 4

Which type of index is automatically created by the database management system to enforce the PRIMARY KEY constraint?

• Clustered index

• Non-clustered index

• Unique index

• Composite index

Question 5

What is a transaction in SQL?

• A set of operations that are executed as a single unit of work

• A temporary storage area used for intermediate data processing

• A constraint that ensures data integrity

• A function that calculates aggregate values

Question 6

Which SQL statement is used to begin a transaction?

• BEGIN TRANSACTION

• START TRANSACTION

• INITIATE TRANSACTION

• TRANSACTION BEGIN

Question 7

What is the purpose of a rollback in SQL?

• To commit the changes made by a transaction

• To save the changes made by a transaction

• To undo the changes made by a transaction

• To finalize the changes made by a transaction

Question 8

Which SQL statement is used to commit a transaction?

• COMMIT

• END TRANSACTION

• SAVE TRANSACTION

• FINALIZE TRANSACTION

Question 9

What is the purpose of a savepoint in SQL transactions?

• To rollback the entire transaction

• To mark a point within a transaction to which you can later roll back

• To commit the changes made by a transaction

• To finalize the changes made by a transaction

Question 10

Which type of index does not alter the physical order of the table's rows and is typically faster to update than a clustered index?

• Clustered index

• Non-clustered index

• Unique index

• Composite index