053(十五）

71、

71.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. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
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.

 

72、

72.You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.
You can use Segment Advisor to _____.
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space

 

73、

73.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
A. You are backing up to tape and your tape device performs its own compression.
B. You are making image copies, and you have not enabled tablespace compression.
C. You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

 

74、

74.Immediately after adding a new disk to or removing an existing disk from an ASM instance, 
you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
A. Define the POWER option while adding or removing the disks.
B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.
D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

 

75、View the Exhibit.

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.
Which background process performs this activity?

 

A. CKPT
B. SMON
C. MMON
D. DBWR

 

转载于:https://www.cnblogs.com/huanhuanang/p/5389773.html