READ Free Dumps For Oracle- 1z0-023
| Question ID 8912 | Which two database tasks can be performed in nomount stage? (Choose two)
|
| Option A | Renaming data files.
|
| Option B | Creating a database.
|
| Option C | Creating a control file.
|
| Option D | Creating a database user
|
| Option E | Opening the redo log files.
|
| Correct Answer | BC |
Explanation Explanation/Reference: Explanation: Answers B and C are correct. It's possible only create database and control file in NOMOUNT stage. Incorrect Answers: A: To rename data files you need to have mounted database. D: To create a database user database must be mounted and opened for usage. E: The redo log files are opened only after database was opened. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 281-283 Chapter 6: Basics of the Oracle Database Architecture
| Question ID 9067 | DRAG DROP
Place the steps for using an EXCEPTIONS table in the correct order.
|
Explanation Explanation/Reference: Explanation: Correct order: Create the EXCEPTIONS table Execute ALTER TABLE with the execution clause Use the EXCEPTION table to locate rows with invalid data. Correct the rows with invalid data Execute ALTER TABLE to enable for constraint You need first create the EXCEPTIONS table, execute ALTER TABLE with the execution clause to find exceptions in data, analyze the EXCEPTIONS table to locate rows with invalid data, correct the rows with invalid data and after that enable constraint for table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 437 Chapter 9: Managing Database Objects II