READ Free Dumps For Oracle- 1z0-023
| Question ID 8765 | Which statement about rebuilding indexes is true?
|
| Option A | The NOSORT option must be used.
|
| Option B | The new index is built using the table as the data source.
|
| Option C | A reverse B-tree index can be converted to a normal index.
|
| Option D | Query performance may be affected because the index is not usable.
|
| Correct Answer | C |
Explanation Explanation/Reference: 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
| Question ID 8766 | When granting the system privilege, which clause enables the grantee to further grant the privilege to other users or roles?
|
| Option A | PUBLIC
|
| Option B | WITH PRIVILEGE
|
| Option C | WITH ADMIN OPTION
|
| Option D | WITH GRANT OPTION
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Clause WITH ADMIN OPTION allows the grantee to grant or revoke the system privilege to other users and roles. Additionally it gives grantee the ability to make other users administrators of that same privilege. Incorrect Answers: A: There is no PUBLIC clause in GRANT command. B: There is no WITH PRIVILEGE clause in GRANT command. D: Clause WITH GRANT OPTION is used to grant object privilege, not system one. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 486 Chapter 10: Managing Database Use