SQL Indexes and Transactions Quiz Quiz

1. Question 1

   What is an index in SQL?

   1. A data structure that stores values in sorted order for fast retrieval
   2. A temporary table used for intermediate data processing
   3. A constraint that ensures data integrity
   4. A function that calculates aggregate values
   5. A data store that stores values in a sorted mannor for fast retrieval

2. Question 2

   Which SQL statement is used to create an index?

   1. CREATE INDEX
   2. ADD INDEX
   3. INDEX TABLE
   4. SET INDEX
   5. MAKE INDEX

3. Question 3

   What is the purpose of an index in SQL?

   1. To enforce data integrity constraints
   2. To store intermediate query results
   3. To improve the speed of data retrieval operations
   4. To perform calculations on aggregate data
   5. To define the structure of a table

4. Question 4

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

   1. Clustered index
   2. Non-clustered index
   3. Unique index
   4. Composite index
   5. Normal index

5. Question 5

   What is a transaction in SQL?

   1. A set of operations that are executed as a single unit of work
   2. A temporary storage area used for intermediate data processing
   3. A constraint that ensures data integrity
   4. A function that calculates aggregate values
   5. A series of queries run on a dataset.

6. Question 6

   Which SQL statement is used to begin a transaction?

   1. BEGIN TRANSACTION
   2. START TRANSACTION
   3. INITIATE TRANSACTION
   4. TRANSACTION BEGIN
   5. NEW TRANSACTION

7. Question 7

   What is the purpose of a rollback in SQL?

   1. To commit the changes made by a transaction
   2. To save the changes made by a transaction
   3. To undo the changes made by a transaction
   4. To finalize the changes made by a transaction
   5. To back up the database

8. Question 8

   Which SQL statement is used to commit a transaction?

   1. COMMIT
   2. END TRANSACTION
   3. SAVE TRANSACTION
   4. FINALIZE TRANSACTION
   5. COMPLETE

9. Question 9

   What is the purpose of a savepoint in SQL transactions?

   1. To rollback the entire transaction
   2. To mark a point within a transaction to which you can later roll back
   3. To commit the changes made by a transaction
   4. To finalize the changes made by a transaction
   5. To automatically save the database state

10. 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?

    1. Clustered index
    2. Non-clustered index
    3. Unique index
    4. Composite index
    5. Clusted index

11. Question 11

    Is a composite index created on single column?

    1. Yes
    2. No
    3. Sometimes
    4. Maybe
    5. I don't know

12. Question 12

    What is the function of Data Definition Language (DDL)?

    1. Data retrieval
    2. Data modification
    3. Data deletion
    4. Data structure definition
    5. Data analysis

13. Question 13

    What is the primary function of Data Manipulation Language (DML)?

    1. Database structure definition
    2. Data retrieval and modification
    3. User access control
    4. Data backup and recovery
    5. Query optimization

14. Question 14

    What property is not part of the ACID properties?

    1. Atomicity
    2. Consistency
    3. Isolation
    4. Durability
    5. Velocity

15. Question 15

    What is Durability in SQL?

    1. Atomicity
    2. Guarantee that transaction changes are permanent
    3. Changes made must maintain data integrity
    4. Ensures that concurrent transactions do not interfere with each other
    5. Database must handle partial failures