This preview shows page 1. Sign up to view the full content.
Unformatted text preview: A. The NOSORT option must be used.
B. The new index is built using the table as the data source.
C. A reverse B-tree index can be converted to a normal index.
D. Query performance may be affected because the index is not usable.
Answer C is correct. A reverse B-tree index can be converted to a normal B-tree index.
A: NOSORT option is required only if data in table are sorted already.
B: All indexes use the table as the data source, not only new one, which is rebuilt.
D: If you are rebuilding index with ONLINE clause query performance will not be affected.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 424-425
Chapter 9: Managing Database Objects II Actualtests.com - The Power of Knowing 1Z0-023
When granting the system privilege, which clause enables the grantee to further grant the
privilege to other users or roles?
B. WITH PRIVILEGE
C. WITH ADMIN OPTION
D. WITH GRANT OPTION
Answer C is correct. Cl...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09