网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
A
After the COPY command.
B
After adding a data file in the target database.
C
After adding a tablespace in the target database.
D
After adding a tablespace in the catalog database.
E
After dropping a data file in the catalog database.
F
After running SQL Loader to load a large amount of data.
参考答案
参考解析
解析：
暂无解析
更多 “多选题In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）AAfter the COPY command.BAfter adding a data file in the target database.CAfter adding a tablespace in the target database.DAfter adding a tablespace in the catalog database.EAfter dropping a data file in the catalog database.FAfter running SQL Loader to load a large amount of data.” 相关考题
考题
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.
考题
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog？（）A、 synch catalogB、 resync catalogC、 replicate catalogD、 update catalogE、 restore catalog
考题
The RVPC user can do which of the following？（）A、 Register databases if granted the register database privilegeB、 See all databases in the recovery-catalog schemaC、 See all database-related metadata in the recovery catalog if they are granted access to that databaseD、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant commandE、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
考题
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.
考题
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（） A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
考题
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
考题
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
考题
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command
考题
You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B、 When a structural change is made to the database， then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D、 When a structural change is made to the database， then a backup of the alert log file will be performed.
考题
You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts； Which command should you issue next？（）A、RESYNC CATALOG；B、REGISTER DATABASE；C、CREATE CATALOG TABLESPACE rman_ts；D、GRANT recovery_catalog_owner TO rman_db01；
考题
You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database
考题
ou have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog? （）A、synch catalog B、resync catalogC、replicate catalog D、update catalog E、restore catalog
考题
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）A、 RMAN would use the current operating system location to place the backup.B、 RMAN would use the control file of the target database to maintain the backup.C、 RMAN would use the recovery catalog of the target database to maintain the backup.D、 RMAN would use the control file of the target database to maintain the backup metadata.E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.
考题
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 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.
考题
多选题If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command
考题
单选题You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A
When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B
When a structural change is made to the database， then a backup of the current control file is performed.C
When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D
When a structural change is made to the database， then a backup of the alert log file will be performed.
考题
单选题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
考题
单选题Which of the following files cannot be cataloged using the CATALOG command？（）A
Data filesB
Control filesC
Archived log filesD
Files storing RMAN scripts
考题
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）A
Issue the grant command from the SYS user （or equivalent） of the target database.B
Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C
Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D
Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E
Issue the grant command from RMAN when connected to the target database.
考题
单选题You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A
rman TARGET / NOCATALOGB
rman TARGET sys/passwordC
rman TARGET sys/password AS SYSDBAD
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）A
RMAN would use the current operating system location to place the backup.B
RMAN would use the control file of the target database to maintain the backup.C
RMAN would use the recovery catalog of the target database to maintain the backup.D
RMAN would use the control file of the target database to maintain the backup metadata.E
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
考题
单选题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 are creating a recovery catalog for use with RMAN. You have issued these commands： SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts； Which command should you issue next？（）A
RESYNC CATALOG；B
REGISTER DATABASE；C
CREATE CATALOG TABLESPACE rman_ts；D
GRANT recovery_catalog_owner TO rman_db01；
考题
单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）A
target databaseB
auxiliary databaseC
third-party databaseD
recovery catalog database
热门标签
最新试卷