Ora parameter file during database creation incorrect

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: eation. Incorrect Answers: 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 QUESTION 96: Which three things can the ALTER INDEX REBUILD command accomplish? (Choose three) 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 Explanation: 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. Incorrect Answers: 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 QUESTION 97: Which statement is incorrect? A. CREATE ROLE sales_clerk; B. CREAT...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online