READ Free Dumps For Oracle- 1z0-023
| Question ID 8841 | Which two actions can be used to multiplex the control file? (Choose two)
|
| Option A | Copy the control file when the database is open.
|
| Option B | Copy the control when the database is shut down.
|
| Option C | Add a control file with the CREATE CONROLFILE command.
|
| Option D | List multiple control files in the parameter file during database creation.
|
| Correct Answer | BD |
Explanation Explanation/Reference: Explanation: Answers B and D are correct. You can copy the control file when the database is shut down or list multiple control files in the initSID.ora parameter file during database creation. 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 ID 8842 | Which three things can the ALTER INDEX REBUILD command accomplish? (Choose three)
|
| Option A | Convert a bitmap index to a B-tree index.
|
| Option B | Move the index to a different tablespace.
|
| Option C | Change the storage parameters for the index.
|
| Option D | Rebuild a reverse index from an existing B-tree index.
|
| Correct Answer | BCD |
Explanation Explanation/Reference: 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