A the nosort option must be used b the new index is

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: Answer C is correct. A reverse B-tree index can be converted to a normal B-tree index. Incorrect Answers: 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 QUESTION 18: When granting the system privilege, which clause enables the grantee to further grant the privilege to other users or roles? A. PUBLIC B. WITH PRIVILEGE C. WITH ADMIN OPTION D. WITH GRANT OPTION Answer: C Explanation: Answer C is correct. Cl...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online