Question

Use secondary index if you want to query a column, which is not a primary key/not part of a composite key.

a) True
b) False

Answer 1

The statement is true; a secondary index is used for querying non-primary key columns for faster data retrieval in databases.

Step-by-step explanation:

The statement is true. In database systems, a secondary index is used to allow efficient querying of columns that are not part of the primary key or a composite key. This index helps improve the performance of queries by providing a quick lookup mechanism for non-primary key columns. Secondary indexes are created on columns other than the primary key, allowing for faster retrieval of specific rows based on the values in those columns. They are beneficial for optimizing queries that involve filtering or sorting on attributes that are not part of the primary key.