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

题目内容 (请给出正确答案)
多选题
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.()
A

SYSAUX

B

TOOLS

C

UNDO

D

INDEX

E

SYSTEM

F

USERS

G

TEMP


参考答案

参考解析
解析: 暂无解析
更多 “多选题Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.()ASYSAUXBTOOLSCUNDODINDEXESYSTEMFUSERSGTEMP” 相关考题
考题 You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?()A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? () A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

考题 Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.) A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.

考题 You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

考题 Examine the following command that is used to duplicate a database on the same host:RMAN RUN{ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ }Which two statements describe the effect after the database is duplicated successfully? ()(Choose two)A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database

考题 You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.() (Choose two.)A、The data file backup is done with multiple channelsB、The data files is in the read-write mode after being backed up in the read only modeC、The backup was taken after the data files was taken offline-normal or is in the read only modeD、The data file backup complies with the back retention policy and the backup duplexing feature

考题 You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()A、The data file backup is done with multiple channelsB、The data files is in the read-write mode after being backed up in the read only modeC、The backup was taken after the data files was taken offline-normal or is in the read only modeD、The data file backup complies with the back retention policy and the backup duplexing feature

考题 Examine the following command that is used to duplicate a database on the same host: RMAN RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? ()(Choose two)A、The data files of the read-only tablespaces in the target database are not duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database

考题 Identify two situations in which you can use Data Recovery Advisor for recovery.() A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.

考题 Examine the following command that is used to duplicate a database on the same host:   RMAN RUN {  ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully?()A、 The data files of the read-only tablespaces in the target database are not duplicatedB、 The read-only tablespaces in the target database are still defined in new the databaseC、 The read-only tablespaces in the target database are changed to online after duplicationD、 The data files of the read-only tablespaces in the target database get duplicatedE、 The read-only tablespaces in the target database are not defined in the new database

考题 Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.()A、SYSAUXB、TOOLSC、UNDOD、INDEXE、SYSTEMF、USERSG、TEMP

考题 Data files of which three tablespaces can be recovered by performing an open recovery?()A、TEMPB、UNDOC、INDEXD、SYSAUXE、SYSTEM

考题 Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)A、The user has dropped an important table that needs to be recovered.B、The database files are corrupted when the database is open.C、You are not able to start up the database instance because the required database files are missing.D、The archived log files are missing for which backup is not available.

考题 多选题Data files of which three tablespaces can be recovered by performing an openrecovery?()ATEMPBUNDOCINDEXDSYSAUXESYSTEM

考题 多选题Examine the following command that is used to duplicate a database on the same host: RMAN RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? ()(Choose two)AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database

考题 多选题Data files of which three tablespaces can be recovered by performing an open recovery?()ATEMPBUNDOCINDEXDSYSAUXESYSTEM

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 多选题Identify two situations in which you can use Data Recovery Advisor for recovery.()AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.

考题 单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation?()A Shut down the database, restore the two data files and then start up the database. B Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

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

考题 单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 多选题Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.

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

考题 多选题Examine the following command that is used to duplicate a database on the same host:   RMAN RUN {  ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully?()AThe data files of the read-only tablespaces in the target database are not duplicatedBThe read-only tablespaces in the target database are still defined in new the databaseCThe read-only tablespaces in the target database are changed to online after duplicationDThe data files of the read-only tablespaces in the target database get duplicatedEThe read-only tablespaces in the target database are not defined in the new database

考题 多选题You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.()AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing feature

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 多选题You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.() (Choose two.)AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing feature