网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）
A
To indicate the location of the auxiliary-instance online redo logs.
B
To indicate the location of the target database datafiles.
C
To indicate the location of the auxiliary-instance control file and online redo logs.
D
To indicate the location of the auxiliary-instance database datafiles.
E
This is not a valid parameter when duplicating a database.
参考答案
参考解析
解析：
暂无解析
更多 “单选题When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）A To indicate the location of the auxiliary-instance online redo logs.B To indicate the location of the target database datafiles.C To indicate the location of the auxiliary-instance control file and online redo logs.D To indicate the location of the auxiliary-instance database datafiles.E This is not a valid parameter when duplicating a database.” 相关考题
考题
You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）A. The source database should be openB. The target database should be in ARCHIVELOG mode if it is openC. RMAN should be connected to both the instances as SYSDBAD. The target database backups should be copied to the source database backup directoriesE. The password file must exist for the source database and have the same SYS user password as the target
考题
Which command do you use to generate a report of database incarnations？（） A、 list incarnation of databaseB、 report incarnation of databaseC、 list database incarnationD、 database incarnation listE、 report database incarnation
考题
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
考题
What RMAN command must you use before you can back up a database using the recovery catalog？（）A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database
考题
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.
考题
If you create your database using Oracle Managed Files （OMF）， what is true？（）A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.
考题
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 configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this？（） A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
考题
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（） A、 To indicate the location of the auxiliary-instance online redo logs.B、 To indicate the location of the target database datafiles.C、 To indicate the location of the auxiliary-instance control file and online redo logs.D、 To indicate the location of the auxiliary-instance database datafiles.E、 This is not a valid parameter when duplicating a database.
考题
You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export and import into the same databaseD、the BACKUP DATABASE and RESTORE DATABASE commands of RMANE、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
考题
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 two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
考题
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
单选题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.
考题
多选题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 configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this？（）A
MAXSETSIZE TO 2B
DEVICE TYPE DISK PARALLELISM 2C
RETENTION POLICY TO REDUNDANCY 2D
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
考题
单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands： RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK； What are the implications of this command？（）A
It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B
It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C
It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D
It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
多选题You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
考题
多选题You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and import into the same databaseDthe BACKUP DATABASE and RESTORE DATABASE commands of RMANEthe BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
考题
单选题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.
考题
多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
考题
单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）A
RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B
RMAN reads the block change tracking file when it performs both incremental backups.C
RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D
RMAN does not read the block change tracking file when it performs either incremental backup.
考题
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A
The alter database archivelog command will failB
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC
The alter database archivelog command will succeedD
The alter database archivelog command will ask if you want to make the database consistent firstE
There is no alter database archivelog command. The correct command is alter database alterlogging
考题
单选题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
热门标签
最新试卷
