You can create a ____ index on a nonpartitioned table.
A) logical partitioned
B) special partitioned
C) global partitioned
D) local partitioned

Question

Quizplus · Accepted Answer

A global partitioned index can be created on a nonpartitioned table. A global partitioned index is a type of index where the index table is partitioned in the same way as the underlying table. This means that the index table is divided into partitions that are constructed and managed in the same way as the underlying table. As a result, a global partitioned index can improve query performance by reducing the amount of data that needs to be scanned or searched.

You Can Create a ____ Index on a Nonpartitioned Table