网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）
A
2，1，3，4，5，6
B
1，3，4，5，6，7
C
1，4，3，5，6，7
D
2，1，3，4，5，6，7
E
1，5，6，4，3，2
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）A 2，1，3，4，5，6B 1，3，4，5，6，7C 1，4，3，5，6，7D 2，1，3，4，5，6，7E 1，5，6，4，3，2” 相关考题
考题
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A、 Database Identifier （DBID）B、 names and location of datafilesC、 names and location of control filesD、 names and location of online redo log files
考题
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
考题
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（） A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.
考题
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）A、 0B、 1C、 NONED、 DEFAULT
考题
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
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 migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）A、 BACKUP AS BACKUPSETB、 BACKUP AS COPYC、 BACKUP AS COMPRESSED BACKUPSETD、 BACKUP INCREMENTAL LEVEL n CUMULATIVE
考题
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
考题
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
考题
单选题n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A
Oracle Migration AssistantB
Recovery Manager （RMAN）C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information about all thenondatabasefiles required to operate the database
考题
单选题You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）A
BACKUP AS BACKUPSETB
BACKUP AS COPYC
BACKUP AS COMPRESSED BACKUPSETD
BACKUP INCREMENTAL LEVEL n CUMULATIVE
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
考题
单选题You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A
Database Identifier （DBID）B
names and location of datafilesC
names and location of control filesD
names and location of online redo log files
考题
单选题You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）A
LIST commandB
CROSSCHECK commandC
REPORT commandD
SHOW command
考题
多选题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
考题
单选题In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）A
Oracle Migration AssistantB
Recovery Manager （RMAN）C
Oracle Data Pump Export and ImportD
conventional Oracle Export and ImportE
operating system utilities to copy the files to the ASM instance
考题
多选题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 are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）A
0B
1C
NONED
DEFAULT
考题
单选题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）A
You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.B
You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.C
You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.D
You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
考题
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A
by using the RMAN utilityB
by using the export/import utilityC
by using the ALTER DATABASE commandD
by enabling the change tracking feature
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
考题
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
考题
单选题You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.（）A
2，1，3，4，5，6B
1，3，4，5，6，7C
1，4，3，5，6，7D
2，1，3，4，5，6，7E
1，5，6，4，3，2
考题
单选题If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）A
Complete database recovery.B
Incomplete database recovery.C
Approximate database recovery.D
Archived database recovery.E
The database could not be recovered with RMAN.
考题
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
热门标签
最新试卷