Multiple choice

Which type of index does the given syntax create?

CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE 30

STORAGE(INITIAL 200K NEXT 200K

PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx;

  1. Bitmap

  2. B-Tree

  3. Partitioned

  4. Reverse key
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The CREATE INDEX syntax shown creates a standard B-tree index, which is Oracle's default index type. B-tree indexes are suitable for high-cardinality columns like last_name where there are many distinct values. Bitmap indexes (option A) are for low-cardinality columns. The syntax shows no partitioning clause (option C) or REVERSE keyword (option D), so it's a regular B-tree index.

Keep practicing — related questions