1Z0-045 試験問題を無料オンラインアクセス

Which three file types are managed by Data Pump jobs? (Choose three.)

• A.out files
• B.dump files
• C.SQL files
• D.alert files
• E.error files
• F.log files

The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?

• A.Enable flashback logging.
• B.Start the database in the ARCHIVELOG mode.
• C.Set the FAST_START_MTTR_TARGET initialization parameter.
• D.Issue the ALTER DATABASE FLASHBACK ON; command.

At 6:00 p.m. you noticed that the database performance was slow between 2:00 p.m. and 6:00
p.m.
due to a series of interrelated problems. You plan to use the Automatic Database Diagnostic Monitor (ADDM) findings for the time period 2:00 p.m. to 6:00 p.m. to resolve the performance issue. The Automatic Workload Repository (AWR) snapshots are made every 30 minutes. What would you do?

• A.Modify the time interval by using the DBMS_JOB.INTERVAL procedure
• B.Look at the latest ADDM report
• C.Check for the ADDM advice trace file in the BACKGROUND_DUMP_DEST directory
• D.Create a custom ADDM task over the period defined by the snapshots taken at 2:00 p.m. and
  6:00 p.m.
• E.Modify the Automatic Workload Repository (AWR) snapshot retention period to four hours
• F.Check the alert log to see if it contains ADDM advice

While using buffer cache advisory, you find that no statistics have been collected. Which task would you perform to collect the statistics?

• A.Wait for the default automatic optimizer statistics generation.
• B.Set DB_CACHE_ADVICE to ON.
• C.Set TIMED_OS_STATISTICS to 100.
• D.Create a custom Automatic Database Diagnostic Monitor (ADDM) task.
• E.Modify the AUTO_TASKS_JOB_CLASS schedule class.
• F.Set ACTIVE_INSTANCE_COUNT to 2.
• G.Set TIMED_STATISTICS to TRUE.
• H.Restart the database instance.
• I.Set STATISTICS_LEVEL to TYPICAL.

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.Both SPFILE and MEMORYmemory values are updated.
• B.Only init<SID>.ora parameters are updated.
• C.Both init<SID>.ora parameters and SPFILE values are updated.
• D.Only SPFILE values are updated.
• E.Only MEMORY is updated.