READ Free Dumps For Oracle- 1z0-023
| Question ID 8773 | In which situation is it appropriate to enable the restricted session mode?
|
| Option A | Creating a table.
|
| Option B | Dropping an index.
|
| Option C | Taking a rollback segment offline.
|
| Option D | Exporting a consistent image of a large number of tables.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. You should use the restricted session mode if you are exporting a consistent image of a large number of tables. Incorrect Answers: A: You don't need to use the restricted session mode to create table. B: You don't need to use the restricted session mode to drop an index. D: You don't need to use the restricted session mode to take a rollback segment offline. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 534-538 Chapter 11: Data Loads and National Language Support
| Question ID 8774 | Which three events are logged in the ALERT file? (Choose three)
|
| Option A | Socket usage
|
| Option B | Block corruption errors
|
| Option C | User session information
|
| Option D | Internal errors (ORA-600)
|
| Option E | Database startup activities.
|
| Correct Answer | BDE |
Explanation Explanation/Reference: Explanation: Answers B, D, E are correct. There are three events: block corruption errors, internal errors (ORA-600), database startup activities, which are logged in the ALERT file. Incorrect Answers: A: Socket usage have nothing to do with ALERT log file. C: The ALERT log does not contain user session information. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 288 Chapter 6: Basics of the Oracle Database Architecture