Unformatted text preview: e statistics have been purged.
B. On Wednesday, the retention period has been set to zero.
C. On Wednesday, the collection interval has been set to zero.
D. On Wednesday, the collection level has been changed to All.
E. On Wednesday, the retention period has been set to one day.
F. On Wednesday, the retention period has been set to two days.
G. On Wednesday, the collection level has been changed to Typical.
H. On Wednesday, the collection interval has been set to 1440 minutes.
One of the user sessions was terminated abnormally in the middle of a transaction.
What does Oracle database do to recover it?
A. uses undo data for roll forward
B. uses Flashback Log for recovery
Actualtests.com - The Power of Knowing 1Z0-042
C. uses online redo logs to roll back
D. uses undo data to roll back the transaction
E. uses Recovery Manager (RMAN) to roll back
F. uses the System Monitor (SMON) background process to perform instance recovery
You are in the middle of a transaction and very crucial data has been modified.
Because of a hardware failure, the instance has shut down before synchronizing all
the database files. Which two statements are true? (Choose two.)
A. On startup, SMON coordinates instance recovery.
B. On startup, CKPT coordinates instance recovery.
C. On startup, use RMAN to perform instance recovery.
D. Uncommitted changes will be rolled back after the database is opened.
E. On startup, perform media recovery and then instance recovery.
F. On startup, all the files will be synchronized and you get both committed and
You want to administer your PROD database from a remote host machine using a
Web-enabled interface. Which Oracle tool would you use to accomplish this task
efficiently without using command-line interfaces?
C. Management Server
D. Management Repository
E. Oracle Enterprise Manager 10g Database Control
You have been recently hired as a database administrator. Your senior manager
asks you to study the production database server and...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09