What would have caused the statistics to be removed a

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: 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. Answer: F QUESTION 162: 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 Answer: D QUESTION 163: 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 uncommitted data. Answer: A,D QUESTION 164: 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? A. SQL*Plus B. iSQL*Plus C. Management Server D. Management Repository E. Oracle Enterprise Manager 10g Database Control Answer: E QUESTION 165: You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and...
View Full Document

Ask a homework question - tutors are online