VOOZH about

URL: https://www.geeksforgeeks.org/quizzes/sql-indexes-transactions-quiz/

⇱ Quiz about SQL Indexes & Transactions Quiz

Last Updated :
Discuss
Comments

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

There are 10 questions to complete.

Take a part in the ongoing discussion