网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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.
参考答案
更多 “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.” 相关考题
考题
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
考题
You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?()
A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
考题
Which two client requests are captured during database replay Capture?() (Choose two)
A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations
考题
Which two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
考题
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 performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)A、The KEEP option overrides the configured retention policyB、The KEEP option is an attribute of an individual backup pieceC、The backup contains only data files and archived redo log filesD、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
考题
Which two statements are true about checkpointing（）A、The checkpoint frequency decreases with the smaller redo log file size.B、It ensures that all committed data is written to the data files during normal shutdown.C、The frequent full checkpoint in a database can cause the overall degradation of the database performance.D、It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
When performing an incomplete recover of the whole database， which data files must you restore？ （）A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
考题
Which two client requests are captured during database replay Capture?（） (Choose two)A、Flashback queriesB、Shared server requestsC、Login and logoff activities of sessionsD、Direct path load of data from external files by using utilities such as SQL *loaderE、Data definition language (DDL) and data manipulation language (DML) operations
考题
Which two statements about the background process of the database writer are true（）A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
考题
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
考题
Which two statements about the background process of thedatabase writerare true（） A、It is possible to have multiple database writers in an Oracle instance.B、It writes dirty buffers， if any， to data files whenever a checkpoint occurs.C、It writes dirty buffers， if any， to data files whenever a transaction commits.D、It writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
考题
The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 control filesB、 password fileC、 archived log filesD、 system-critical data files for which all the redo entries are presentE、 non-system-critical data files for which all the redo entries are present
考题
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 performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)AThe KEEP option overrides the configured retention policyBThe KEEP option is an attribute of an individual backup pieceCThe backup contains only data files and archived redo log filesDThe backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled
考题
多选题Which two client requests are captured during database replay Capture?（） (Choose two)AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language (DDL) and data manipulation language (DML) operations
考题
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）A
Only the damaged or lost data files.B
All of the data files of the database.C
Only the data files belonging to the SYSTEM tablespace.D
The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
考题
多选题Which two statements about the background process of thedatabase writerare true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes.
考题
单选题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.
考题
多选题Which two statements about the background process of the database writer are true（）AIt is possible to have multiple database writers in an Oracle instance.BIt writes dirty buffers， if any， to data files whenever a checkpoint occurs.CIt writes dirty buffers， if any， to data files whenever a transaction commits.DIt writes dirty buffers， if any， to data files before the log writer （LGWR） writes
考题
多选题Which two statements correctly describe the relation between a data file and the logical databasestructures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
考题
多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all the redo entries are present
考题
单选题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 the two tablespaces whose data files are so critical that only a closed recovery is possible.（）ASYSAUXBTOOLSCUNDODINDEXESYSTEMFUSERSGTEMP
考题
多选题Which two statements are true about checkpointing（）AThe checkpoint frequency decreases with the smaller redo log file size.BIt ensures that all committed data is written to the data files during normal shutdown.CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.DIt prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.
考题
单选题You issued the following commands to configure setting in RMAN; RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; 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
考题
多选题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
热门标签
最新试卷
