Oracle - Indexes MCQ

Oracle – Indexes

1 / 25

1. What is the primary purpose of an Oracle index?

Speed up data retrieval

Enhance data visualization

Reduce data storage

Improve data security

2 / 25

2. Which type of index in Oracle allows duplicate values?

Clustered index

Bitmap index

B-tree index

Unique index

3 / 25

3. What is the main advantage of a bitmap index in Oracle?

Provides uniqueness constraints

Works well for low-cardinality columns

Requires less storage space

Supports fast range queries

4 / 25

4. In Oracle, which type of index is often used for columns with high cardinality and uniqueness?

B-tree index

Function-based index

Bitmap index

Reverse key index

5 / 25

5. What is a function-based index in Oracle?

An index that is created on a virtual column

An index that uses mathematical functions

An index that supports wildcard searches

An index that allows special characters

6 / 25

6. Which type of index in Oracle is used for text search operations?

Bitmap index

Clustered index

Full-text index

Function-based index

7 / 25

7. What is the purpose of a composite index in Oracle?

Allow only one row in the table

Ensure uniqueness of a single column

Store binary data efficiently

Speed up queries on multiple columns

8 / 25

8. Which index type in Oracle is automatically created for the primary key or unique constraint of a table?

B-tree index

Reverse key index

Bitmap index

Function-based index

9 / 25

9. In Oracle, what is the main purpose of a reverse key index?

Avoid index contention

Improve data security

Enhance data visualization

Reduce fragmentation

10 / 25

10. Which index type in Oracle is most suitable for columns with low cardinality and repetitive values?

Function-based index

Reverse key index

B-tree index

Bitmap index

11 / 25

11. What is the purpose of a cluster index in Oracle?

Speed up data retrieval from multiple tables

Store large text documents efficiently

Improve query performance for date columns

Ensure uniqueness of a single column

12 / 25

12. In Oracle, what is an invisible index?

An index that cannot be used by any query

An index that only stores metadata

An index that is hidden from the database administrator

An index that is not automatically created

13 / 25

13. Which index type in Oracle is used to enforce uniqueness constraints on a column or set of columns?

Unique index

Function-based index

Bitmap index

B-tree index

14 / 25

14. What is the purpose of a bitmap join index in Oracle?

Ensure data integrity

Improve data compression

Store encrypted data

Speed up joins between two or more tables

15 / 25

15. In Oracle, what is the main benefit of using a reverse key index?

Enhanced security

Faster index creation

Improved query performance for certain workloads

Reduced storage requirements

16 / 25

16. Which Oracle index type is typically used for columns with a high degree of data skew?

Function-based index

Bitmap index

Clustered index

B-tree index

17 / 25

17. What is a bitmap join index in Oracle?

An index that joins two tables physically

An index that facilitates joins between fact and dimension tables

An index that supports full-text search

An index that stores only bitmap values

18 / 25

18. In Oracle, what is the purpose of a domain index?

Enhance data visualization

Speed up queries on user-defined data types

Improve data security

Store geographic data

19 / 25

19. Which index type in Oracle is best suited for columns with a small number of distinct values and high data entropy?

Function-based index

B-tree index

Reverse key index

Bitmap index

20 / 25

20. What is the main purpose of a global index in Oracle?

Indexes data within a single table

Indexes data across multiple tables in different schemas

Reduces index maintenance overhead

Supports only local queries

21 / 25

21. In Oracle, what is a compressed index?

An index that cannot be created manually

An index that only stores metadata

An index that uses data compression techniques

An index that cannot be accessed by queries

22 / 25

22. Which index type in Oracle is commonly used for spatial data?

Function-based index

Bitmap index

Spatial index

B-tree index

23 / 25

23. What is the primary purpose of a bitmap index in Oracle?

Improve data security

Store multimedia data

Speed up queries with low cardinality columns

Enhance data visualization

24 / 25

24. Which type of index in Oracle is most suitable for wildcard searches?

Bitmap index

B-tree index

Full-text index

Function-based index

25 / 25

25. In Oracle, what is the purpose of a reverse key compressed index?

To ensure data integrity

To improve query performance for range queries

To save disk space

To speed up insert operations

Your score is

0%

Oracle – Indexes MCQ