网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Why would you run the delete obsolete command？（）
A
To remove missing backup set pieces physically from disk
B
To remove metadata related to backup set pieces in the control file and the recovery catalog
C
To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
D
To delete backup set pieces associated with backups that are no longer needed due to retention criteria
E
To remove old versions of RMAN backups
参考答案
参考解析
解析：
暂无解析
更多 “多选题Why would you run the delete obsolete command？（）ATo remove missing backup set pieces physically from diskBTo remove metadata related to backup set pieces in the control file and the recovery catalogCTo mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsDTo delete backup set pieces associated with backups that are no longer needed due to retention criteriaETo remove old versions of RMAN backups” 相关考题
考题
单选题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
考题
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A
Enable the flash recovery area and specify it as the archived redo log destination.B
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C
Enable the flash recovery area but do not specify it as the archived redo log destination. D
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
单选题Which statement about recovering from the loss of a redo log group is true?（）A
If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B
If the lost redo log group is CURRENT, you must clear the log file.C
If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D
If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
考题
多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
考题
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A
XIDB
VERSIONS_PKC
VERSIONS_XIDD
VERSIONS_UNIQUE
考题
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You could consider performing the following steps to accomplish this task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file. 3） Start the target database Instance. 4） Mount the database. 5） Restore the data files. 6） Open the database with the RESETLOGS option. 7） Recover the data files. 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A
8， 1， 3， 2， 4， 5， 7， 6B
1， 8， 3， 4， 2， 5， 7， 6C
1， 3， 4， 2， 8， 5， 6， 7D
1， 3， 2， 4， 6， 5， 7， 8
考题
多选题Which of the following statements are true regarding the Recycle Bin？（）AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
考题
多选题Which two client requests are captured during database replay Capture?（） (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations
考题
单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task？（）A
Set metric thresholdB
Implement Database Resource ManagerC
Enable resumable timeout for user sessionsD
Add directives to Automatic Database Diagnostic Monitor （ADDM）
考题
多选题Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）ACursor cacheBStored outlineCSQL Tuning SetDAutomatic Workload Repository （AWR） snapshots
考题
单选题You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242， registered in RCAT10， into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this： RMAN CONNECT CATALOG rco11/password@catdb RMAN IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242； What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）A
The scripts in the RCO11 catalog are overwritten.B
RMAN renames the local stored scripts in the RCO11 catalog.C
The RMAN session in which the command is executed aborts.D
RMAN renames the global scripts that are imported from the RCAT10 catalog.
考题
单选题Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower？（）A
Differential incremental backupB
Different incremental backupC
Cumulative backupD
Cumulative incremental backup
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true？（）A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
单选题Which of the following methods can be used to detect block corruption？（）A
ANALYZE operationsB
dbvC
SQL queries that access the potentially corrupt blockD
RMANE
All of the above
考题
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
单选题Which of the following is not a valid calendaring syntax element？（）A
FREQB
BYHOURC
RUNDATED
INTERVALE
BYMINUTE
考题
单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）A
Implement job classesB
Implement Scheduler windowsC
Implement the mapping rule for the consumer groupsD
Set the SWITCH_TIME resource plan directive for both the resource plans
考题
单选题While tuning a SQL statement， the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation？（）A
It updates the existing SQL profiles with current statisticsB
It makes the statistics information available to GATHER_STATS_JOBC
It initiates the statistics collection process by running GATHER_STATS_JOBD
It logs a warning message in the alert log so that the DBA can perform statistics collection manually
考题
多选题To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）ALOG_HISTORYBJOB_LOG_RETENTIONCWINDOW_LOG_RETENTIONDWHICH_LOGELOG_NAME
考题
多选题You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file， if it has already been backed up.（）AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing fe ture
考题
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（）A
You should perform a log switchB
You should make a backup of the databaseC
You should switch the database to the NONARCHIVELOG modeD
You should shut down the database instance and perform a complete database recovery
考题
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）A
statistics recommendationsB
SQL Profile recommendationsC
Index-related recommendationsD
restructuring of SQL recommendations
考题
多选题Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）AIt is used to change failure priority only for HIGH or LOW priorities.BIt is used to execute the advised repair script.CIt is used to change failure priority only for the CRITICAL priority.DIt is used to explicitly close the open failures.EIt is used to inform the database about the repair after the repair script executes.
考题
单选题Which package provides API’s for the SQL Tuning Advisor？（）A
DBMS_MONITORB
DBMS_STATSC
DBMS_SQLTUNED
DBMS_ADVISOR
考题
多选题What two are the prerequisites for enabling Flashback Database？（）AThe database must be in ARCHIVELOG modeBThe database must be in MOUNT EXCLUSIVE modeCThe database must be opened in RESTRICTED modeDThe database instance must be started in the NOMOUNT stateEThe database instance must have the keep buffer pool defined
考题
单选题Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）A
The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.B
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.C
If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.D
If you restart the database, the database will not be opened.
热门标签
最新试卷