Question: A partitioned table TABLE 5 includes columns A , B , . . . , Z ( A through Z ) . The table is

A partitioned table TABLE5 includes columns A, B,..., Z (A through Z). The table is partitioned by columns B, D, and T (B,D,T). The following index is created on the table:
CREATE INDEX INDEX5 ON TABLE5(B,T,D ASC) PARTITIONED;
What type of index is INDEX5?
Question 17Select one:
A.
A NPSI (non-partitioned secondary index)
B.
A data partitioned, partitioning index
C.
A DPSI (data partitioned secondary index)
D.
A data partitioned, primary index

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!