1Z0-052 · Question #137
View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the t
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column. Which type of index would you select in this scenario?
Exhibit
Options
- ABitmap index
- BReverse key index
- CNormal BTree index
- DFunctionbased index
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.