Files can be lost or destroyed accidentally.Keep ______ copies of all data on removable storage media.
A.backup
B.back
C.black
D.backdown
第1题:
Which two statements correctly describe the relation between a data file and the logical databasestructures()
第2题:
Which statements are true about checkpointing()
第3题:
Which two statements are true about checkpointing()
第4题:
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode?()
第5题:
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?()
第6题:
The data files can be recovered till the last committed transaction.
The data files can be recovered without shutting down the database.
The data file is taken offline automatically; the database remains open.
The data files can be recovered to the time of the most recent backup.
第7题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.
第8题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第9题:
You can perform consistent backups only.
You can perform a complete database backup without shutting down the database instance.
You can back up data files only when all data files have the same SCN recorded in the control file.
You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.
第10题:
import the database from the last export
restore all the members in the group from the last backup
drop the lost member from the database and then add a new member to the group
restore all the database files from the backup and then perform a complete recovery
restore all the database files from the backup and then perform an incomplete recovery
第11题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第12题:
The instance aborts.
The database cannot be recovered.
The database can be recovered by restoring the control files from the backup.
The database remains opened and you have to shut it down with the ABORT option.
The database can be restored till the point of the last closed whole database backup.
第13题:
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()
第14题:
Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode?()
第15题:
When performing an incomplete recover of the whole database, which data files must you restore? ()
第16题:
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?()
第17题:
Only the damaged or lost data files.
All of the data files of the database.
Only the data files belonging to the SYSTEM tablespace.
The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
第18题:
The data files can be recovered till the last committed transaction.
The data files can be recovered without shutting down the database.
The data file is taken offline automatically; the database remains open.
The data files can be recovered to the time of the most recent backup.
第19题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online
第20题:
restore all the data files from last Sunday’s backup, and then perform a timebased recovery
restore all the data files from last Sunday’s backup, and then perform a cancelbased recovery
restore all the data files from last Sunday’s backup, and then perform a changebased recovery
restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup, and then perform a complete recovery
第21题:
The checkpoint frequency decreases with the smaller redo log file size.
It ensures that all committed data is written to the data files during normal shutdown.
The frequent full checkpoint in a database can cause the overall degradation of the database performance.
It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
第22题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
第23题:
Restore the lost data file from the backup, and then flash back the database.
Restore the data file pertaining to index tablespace, and then recover the tablespace.
Restore all the data files, and then perform an incomplete recovery to get the tablespace back.
Restore all the data files, and then perform an incomplete recovery using the backup control file.
Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.