网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Files can be lost or destroyed accidentally．Keep ______ copies of all data on removable storage media.
A．backup
B．back
C．black
D．backdown
参考答案
更多 “ Files can be lost or destroyed accidentally．Keep ______ copies of all data on removable storage media.A．backupB．backC．blackD．backdown ” 相关考题
考题
Files can be lost or destroyed accidentally. Keep(74) copies of all data on removable storage media.A．moveB．pasteC．backdownD．backup
考题
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
考题
Files can be lost or destroyed accidentally．Keep (74) copies of all data on removable storage media．A．backupB．backC．blackD．backdown
考题
Regarding disk scrub， which two of these occur to the data on any local drives upon disassociation？ （）A、 If disk scrub is enabled， all BIOS settings for the server are erased.B、 If disk scrub is enabled， all the data access on any local drives is destroyed.C、 If disk scrub is enabled， the LSI active RAID is destroyed but data is still preserved.D、 If disk scrub is disabled， all data on any local drives is preserved， including the local storage configuration.E、 If disk scrub is enabled， all data on any local drives is preserved， including the local storage configuration.
考题
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.
考题
Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
考题
Which 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 onlineredo log files
考题
Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）A、The data files can be recovered till the last committed transaction.B、The data files can be recovered without shutting down the database.C、The data file is taken offline automatically; the database remains open.D、The data files can be recovered to the time of the most recent backup.
考题
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 statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）A、The data files can be recovered till the last committed transaction.B、The data files can be recovered without shutting down the database.C、The data file is taken offline automatically； the database remains open.D、The data files can be recovered to the time of the most recent backup.
考题
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
考题
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure. How would you recover the lost redo log member？（）A、import the database from the last exportB、restore all the members in the group from the last backupC、drop the lost member from the database， and then add a new member to the groupD、restore all the database files from the backup， and then perform a complete recovery E、restore all the database files from the backup， and then perform an incomplete recovery
考题
单选题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 statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）A
The data files can be recovered till the last committed transaction.B
The data files can be recovered without shutting down the database.C
The data file is taken offline automatically； the database remains open.D
The data files can be recovered to the time of the most recent backup.
考题
单选题Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）A
The data files can be recovered till the last committed transaction.B
The data files can be recovered without shutting down the database.C
The data file is taken offline automatically; the database remains open.D
The data files can be recovered to the time of the most recent backup.
考题
多选题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.
考题
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace 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
考题
单选题Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）A
restore all the data files from last Sunday’s backup， and then perform a timebased recoveryB
restore all the data files from last Sunday’s backup， and then perform a cancelbased recoveryC
restore all the data files from last Sunday’s backup， and then perform a changebased recoveryD
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery
考题
多选题You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
考题
多选题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.
考题
单选题In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A
import the database from the last exportB
restore all the members in the group from the last backupC
drop the lost member from the database and then add a new member to the groupD
restore all the database files from the backup and then perform a complete recoveryE
restore all the database files from the backup and then perform an incomplete recovery
考题
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）A
Take the USERS tablespace offline and re-create the lost data file.B
Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C
Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D
Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
考题
单选题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 lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
考题
多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
热门标签
最新试卷
