单项选择题

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.
What action would you take to achieve this task（）

A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D.Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

<上一题目录下一题>

热门试题

单项选择题View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）

A.You have chosen the File System option as the storage option.
B.You have chosen the Automatic Storage Management （ASM） as the storage option.
C.The data block size can be increased only when DBCA is invoked from Oracle Universal Installer （OUI）.
D.You are using General Purpose template and not the Custom Database template to create the database

多项选择题WhichstatementsaretrueregardingtheOracleDataPumpexportandimportoperations（）

A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported

多项选择题Whichstatementsaretrueaboutcheckpointing（）

A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database performance.
D.It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the onlineredo log files

多项选择题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

A.The online redo log files and online data files are opened.
B.All the online data file headers are checked for consistency.
C.Instance recovery is performed before opening the database.
D.The path and existence of all the log file members are checked

单项选择题InwhichsituationistheUNDO_RETENTIONparameterbeignored，evenifitissettoavalue（）

A.When the data file of the undo tablespace is autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）

Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.
What action would you take to achieve this task（）