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

题目内容 (请给出正确答案)
单选题
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
A

 Create a backup of the database and recover all corrupted blocks found in the backup.

B

 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

C

 Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.

D

 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.

E

 Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()A  Create a backup of the database and recover all corrupted blocks found in the backup.B  Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C  Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.D  Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.E  Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.” 相关考题
考题 View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process() A. 4B. 8C. 7D. 0

考题 Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

考题 View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

考题 Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED

考题 You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

考题 RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A、’SQL ALTER DATABASE OPEN’;B、SQL ALTER DATABASE ’OPEN’;C、OPEN DATABASE;D、DATABASE OPEN

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 You issued the following statement:   SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n;   What will be the result of issuing the above statement?()A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.

考题 When performing a full database disaster recovery with RMAN, in what order would you execute these steps?()   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command. A、 a, b, c, d, e, fB、 c, d, a, b, fC、 d, c, a, b, fD、 d, b, d, c, eE、 d, c, a, b, e

考题 You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

考题 View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:   RMAN RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }   What is the multiplexing level in the preceding backup process?()A、 4B、 8C、 7D、 0

考题 You execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows:  RMAN/x7f03009: failure of allocate command on c1 channel  ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name:  What could explain why the statement failed?()A、sbt is not a valid device type.B、Media Management Library was not loaded.C、The sbt device cannot be used for data file backups.D、No path was defined in the ALLOCATE CHANNEL command.E、The channel is currently being used by another RMAN session.

考题 You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups?()A、 You need to mention it with every BACKUP command.B、 The block change tracking feature is used automatically by RMAN.C、 You need to configure it using the CONFIGURE command.D、 You need to set the necessary initialization parameters to direct RMAN to use the feature.

考题 Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题Which statement about using RMAN stored scripts is true?()A  To create and execute an RMAN stored script,you must use a recovery catalog.B  When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C  RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D  When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题You issued the following statement:   SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n;   What will be the result of issuing the above statement?()A The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B  The command will not execute successfully because resumable space allocation is enabled at the session level.C  The command will execute successfully and resumable space will be allocated at the session level.D  The command will execute successfully and resumable space will be allocated at the instance level.

考题 多选题You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()ACorrupted blocks, if any, are repaired.BChecks are performed for physical corruptions.CChecks are performed for logical corruptions.DChecks are performed to confirm whether all database files exist in correct locationsEBackup sets containing both data files and archive logs are created.

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A  back up the control file to traceB  bring database to the MOUNT stateC  open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD  set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A  OPENB  MOUNTC  NORMALD  NOMOUNT

考题 单选题View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:   RMAN RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }   What is the multiplexing level in the preceding backup process?()A  4B  8C  7D  0

考题 单选题When performing a full database disaster recovery with RMAN, in what order would you execute these steps?()   a. Restore the control file from autobackups.  b. Run the RMAN restore and recover command.  c.Restore the database spfile from autobackups.  d. Make the RMAN backup set pieces available.  e. Open the database with the alter database open resetlogs command.  f.Open the database with the alter database open command.A  a, b, c, d, e, fB  c, d, a, b, fC  d, c, a, b, fD d, b, d, c, eE d, c, a, b, e

考题 单选题Which statement about using RMAN stored scripts is true?()A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()A Data files that belong to only the root containerB Data files that belong to the root container and all the pluggable databases (PDBs)C Data files that belong to only the root container and PDB$SEEDD Data files that belong to the root container and all the PDBs excluding PDB$SEED

考题 多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

考题 单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

考题 单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days

考题 单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A  configure a default device for RMAN backupsB  temporarily disable the retention policy for RMAN backupsC  configure automatic channel allocation for RMAN backupsD  use the CONFIGURE command to reconfigure the recovery window to 60 days

考题 多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block