The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only.  What is the order of precedence?() 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGUREA、1,2,3 B、2,3,1 C、3,2,1 D、There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.

The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only.  What is the order of precedence?() 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGURE

  • A、1,2,3 
  • B、2,3,1 
  • C、3,2,1 
  • D、There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session. 

相关考题:

Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?() A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database:  SET UNTIL TIME = ’2000-12-09:11:44:00’;  RESTORE DATABASE; RECOVER DATABASE;  How should the commands be executed? ()A、Only the SET command must be within a RUN block.B、All commands should be executed at the RMAN prompt.C、All three commands must be within a single RUN block.D、Only the RESTORE and RECOVER commands must be within a single RUN block.

hich of the following RMAN structures can data from a datafile span?()A、RMAN backup-set pieces spanning backup sets B、RMAN backup-set pieces within a given backup sets C、RMAN backups D、RMAN channels E、None of the above

Which of the following commands will be run at a command prompt to determine which WindowsOS is running on the computer?()A、VERB、Device ManagerC、VERIFYD、SET

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

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 used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

If a backup set is expired, what can you do to correct the problem?()  A、 Change the retention criteria.B、 Make the lost backup set pieces available to RMAN again.C、 Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D、 Nothing. The backup set piece is lost forever.E、 Call Oracle support,their assistance is required.

Which of the following RMAN structures can data from a datafile span?()A、 RMAN backup-set pieces spanning backup setsB、 RMAN backup-set pieces within a given backup setC、 RMAN backupsD、 RMAN channelsE、 None of the above

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:   SQL startup ORA-01078: failure in processing system parameters LRM-00109:  could not open parameter file ,  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN,   how would you respond to this error?()  A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E、 Issue the restore spfile from autobackup command from the RMAN prompt.

You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()A、by using the trace fileB、by using the alert log fileC、by using the database IDD、by using the server parameter fileE、by using the V$CONTROLFILE viewF、by using the autobackup format configuration setting

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.

When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations?()A、At the end of every RUN block. B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. C、After every BACKUP or COPY command issued at the RMAN prompt. D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

Which of the following actions will allow you to convert from Windows Server 2012 R2 Standard to Windows Server Datacenter, using the least administrative effort?()A、You should run Setup from the installation media.B、You should run the Install-WindowsFeature cmdlet from the Windows PowerShell.C、You should run the dism /online /add-package command from an elevated command prompt.D、You should run the dism /online /enable-feature command from an elevated command Prompt.E、You should run the dism /online /set-edition command from an elevated command prompt.

单选题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.

多选题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

多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()ABy using the trace file.BBy using the alert log file.CBy using the database IDDBy using the server parameter file.EBy using the V$CONTROLFILE view.FBy using the autobackup format configuration setting.

单选题Which of the following RMAN structures can data from a datafile span?()A RMAN backup-set pieces spanning backup setsB RMAN backup-set pieces within a given backup setC RMAN backupsD RMAN channelsE None of the above

单选题If a backup set is expired, what can you do to correct the problem?()A Change the retention criteria.B Make the lost backup set pieces available to RMAN again.C Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D Nothing. The backup set piece is lost forever.E Call Oracle support,their assistance is required.

多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()AA tablespace is taken offline.BThe database instance is restarted.CA new data file is added to an existing tablespace.DA successful backup is recorded in the RMAN repository.EThe RMAN connection is disconnected from the target database.

多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

单选题The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only.  What is the order of precedence?() 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGUREA1,2,3 B2,3,1 C3,2,1 DThere is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.

多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile

多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()Aby using the trace fileBby using the alert log fileCby using the database IDDby using the server parameter fileEby using the V$CONTROLFILE viewFby using the autobackup format configuration setting