Database Query Indexing Basics Quiz

1. What does ACID stand for in database transactions?

Atomicity, Consistency, Isolation, Durability

Authorization, Control, Integration, Data

Accuracy, Completeness, Integrity, Distinctness

Access, Concurrency, Index, Dependency

2. True or False: A hash index is ideal for range queries.

True

False

3. What does query optimization primarily focus on?

Reducing execution time and resource usage

Making queries easier to read

Adding more indexes automatically

Increasing data redundancy

4. True or False: Denormalization always improves database performance.

True

False

Submit

6. Which indexing strategy involves storing row addresses directly?

Clustered index

Non-clustered index

Full-text index

Spatial index

7. True or False: A table can have multiple primary keys.

True

False

8. What is a primary key's main function?

To uniquely identify each row in a table

To store encrypted passwords

To automatically increment values

To link tables together

Submit

10. Which operation is most efficient on an indexed column?

SELECT with WHERE clause

INSERT new rows

UPDATE multiple records

DELETE all rows

11. What is the primary purpose of an index in a database?

To speed up data retrieval operations

To reduce storage space requirements

To enforce referential integrity

To automatically backup the database

Submit

13. What is the purpose of a foreign key in relational databases?

To establish relationships between tables

To automatically sort records

To replace primary keys

To encrypt sensitive data

14. Which normal form eliminates transitive dependencies?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Submit

16. What is database normalization primarily designed to achieve?

Reduce data redundancy and improve data integrity

Speed up all queries automatically

Eliminate the need for indexes

Compress database files

17. Which of the following is a disadvantage of creating too many indexes?

Slows down INSERT, UPDATE, and DELETE operations

Reduces query result accuracy

Increases data redundancy only in SELECT queries

Prevents foreign key constraints from working

18. In SQL query execution, what is a query plan?

A step-by-step strategy for executing a query

A backup of the original query

A list of all database constraints

A scheduled job for data maintenance

19. What does a composite index contain?

Multiple columns in a single index

Multiple tables combined

Compressed data from several indexes

Temporary copies of table data

20. Which index type uses a tree structure to organize keys?

Hash index

B-tree index

Bitmap index

Full-text index

General Databases Intermediate Query Indexing Basics Quiz

1. What does ACID stand for in database transactions?

2.

What first name or nickname would you like us to use?

2. True or False: A hash index is ideal for range queries.

3. What does query optimization primarily focus on?

4. True or False: Denormalization always improves database performance.

5. A _____ is a virtual table created by a query that can be used like a regular table.

6. Which indexing strategy involves storing row addresses directly?

7. True or False: A table can have multiple primary keys.

8. What is a primary key's main function?

9. A _____ is a set of SQL statements executed as a single unit.

10. Which operation is most efficient on an indexed column?

11. What is the primary purpose of an index in a database?

12. A _____ join returns only rows that have matching values in both tables.

13. What is the purpose of a foreign key in relational databases?

14. Which normal form eliminates transitive dependencies?

15. A _____ is a constraint that ensures every value in a column is unique.

16. What is database normalization primarily designed to achieve?

17. Which of the following is a disadvantage of creating too many indexes?

18. In SQL query execution, what is a query plan?

19. What does a composite index contain?

20. Which index type uses a tree structure to organize keys?