This preview shows page 1. Sign up to view the full content.
Unformatted text preview: eation.
A: You cannot multiplex the control file when the database is open.
C: You cannot multiplex control file with CREATE CONTROLFILE command.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 319-324
Chapter 7: Managing the Physical Database Structure
Which three things can the ALTER INDEX REBUILD command accomplish? (Choose
A. Convert a bitmap index to a B-tree index.
B. Move the index to a different tablespace.
C. Change the storage parameters for the index.
D. Rebuild a reverse index from an existing B-tree index.
Answer: B, C, D
Answers B, C, D are correct. You can move the index to a different tablespace, change the
storage parameters for the index, rebuild a reverse index from an existing B-tree index.
A: It is not possible to convert a bitmap index to a B-tree-index with this command.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 424-425
Chapter 9: Managing Database Objects II
Which statement is incorrect?
A. CREATE ROLE sales_clerk;
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09