Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 8w52ceb345

Examine the output:SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE’;INDEX_NAME STATUS--------------------- -----------------EIND UNUSABLEWhich two statements about...

Examine the output:

SQL> SELECT index_name, status FROM dba_indexes WHEREstatus='UNUSABLE’;

INDEX_NAME STATUS

--------------------- -----------------

EIND UNUSABLE

Which two statements about this index are true?

A.

It is ignored by the query optimizer.

B.

It is not used while the index is being rebuilt.

C.

The index cannot be rebuilt, and has to be re-created.

D.

The index is automatically rebuilt when used the next time.

1z0-497 PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now 1z0-497 pdf
Get 60% Discount on All Products, Use Coupon: "8w52ceb345"