Online Access Free 1Z0-045 Practice Test

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

• A.Modify the AWR snapshot time interval to two hours.
• B.Create two custom ADDM tasks.
• C.Create a new scheduler window for a time period of two hours.
• D.Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
• E.Modify the time interval by using the DBMS_JOB.INTERVAL procedure.

The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

• A.Only init<SID>.ora parameters are updated.
• B.Only MEMORY is updated.
• C.Both SPFILE and MEMORYmemory values are updated.
• D.Both init<SID>.ora parameters and SPFILE values are updated.
• E.Only SPFILE values are updated.

Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recovery strategy available in Oracle 10g?

• A.Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
• B.Take the individual data file offline (not the wholetablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
• C.Rebuild the index using the online option.
• D.Take the individual data file (not the wholetablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

• A.execute the ROLLBACK command with transaction number
• B.point-in-time recovery
• C.determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
• D.manually enter the appropriate data again
• E.flashback the database to before the transaction was committed

Oracle 10g supports block media recovery. This reduces the smallest unit of recovery from a data file to a database block. What are the two main benefits that block media recovery provides over file-level recovery? (Choose two.)

• A.allows increased data availability during media recovery
• B.supports incomplete recovery
• C.does not require Recovery Manager
• D.lowers the mean time to recover (MTTR)