Database Indexes

Which Tree Data Structures have proven particularly efficient for data retrieval in RDBMS?

• A+ Trees

• B+ Trees

• C+ Trees

• Binary Search Trees

The following are types of indexes except

• Clustered index

• Primary index

• Secondary index

• Composite index

An index can be created on several data attributes at once.

• True

• False

Which kind of index is a physically sorted data structure on unique data attributes?

• Primary index

• Clustered index

• Secondary index

_ indexes address each separate search key in one assigned tree node or leaf.

• Dense

• Sparse

A primary index is by nature a _ index.

What is the purpose of a non-clustered index?

• It is used for sorting the data physically

• It is used for faster retrieval of data based on key values

• It is used for creating a clustered index

• None of the above

What is the correct syntax for creating an index in a database?

• INSERT INDEX index_name ON table_name;

• INSERT INDEX index_name ON database_name;

• CREATE INDEX index_name ON database_name;

• CREATE INDEX index_name ON table_name;

Indexes can be deleted.

• TRUE

• FALSE