网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this?()
A

 Create and populate a SQL Tuning Set from the AWR on every Monday.

B

 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

C

 Create a repeating baseline template.

D

 Insert a finding directive for future ADDM tasks.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this?()A  Create and populate a SQL Tuning Set from the AWR on every Monday.B  Change the RETENTION setting for the AWR snapshots to 7 days on Monday.C  Create a repeating baseline template.D  Insert a finding directive for future ADDM tasks.” 相关考题
考题 单选题You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?()A  The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B  The job affinity is to a service and one node in that service is unavailable.C  The job affinity is to an instance and that instance is unavailable.D  There is no service affinity.E  None of the above.

考题 单选题Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()A  Configure backup optimizationB  Configure the channel to increase MAXOPENFILESC  Configure the channel to increase the capacity with the RATE parameterD  Configure the channel to adjust the tape buffer size with the BLKSIZE option

考题 单选题While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files.  What implications does it have on the backup of the flash recovery area?()A  The backup fails because one of the archived redo log files is missing.B  The backup succeeds but it would be without the missing archived log.C  During backup,you are prompted for the alternative destination for the missing archived redo log file.D  The backup succeeds because it fails over to one of the alternative archived redo log destinations.

考题 单选题When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?()A  Export the tablespaces using data pump.B  Determine if the transportable set is self-contained.C  Convert the datafiles using RMAN.D  Copy the datafiles from source to destination.

考题 多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?()AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up

考题 单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted.  What steps should you take to recover from this tempfile loss in an efficient manner?()A  Allow the database to continue running,drop the TEMP tablespace,and then re-create it with new tempfilesB  Shut down the database, restore and recover the tempfile from backup,and then open the database with RESETLOGSC  Allow the database to continue running,take the TEMP tablespace offline,drop the missing tempfile,and then create a new tempfileD  Allow the database to continue running,add a new tempfile to TEMP tablespace with a new name,and drop the tempfile that has been corrupted

考题 单选题In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?()A  The datafiles have an ONLINE status.B  The datafiles have an OFFLINE status.C  The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D  The datafiles have an OFFLINE status and are in hot backup mode for an online backup.E  The datafiles are in STANDBY mode.

考题 单选题What does it mean if a backup is expired?()A  The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B  The backup set has one or more invalid blocks in it and is not usable for recovery.C  The backup set contains one or more tablespaces no longer in the database.D  The backup set contains one or more missing backup set pieces.E  The backup set is from a previous version of RMAN and was not upgraded.

考题 多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.