单选题You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?()ARECOVERY_PARALLELISMBFAST_START_MTTR_TARGETCLOG_CHECKPOINT_INTERVALDFAST_START_PARALLEL_ROLLBACK
单选题
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?()
A
RECOVERY_PARALLELISM
B
FAST_START_MTTR_TARGET
C
LOG_CHECKPOINT_INTERVAL
D
FAST_START_PARALLEL_ROLLBACK
参考解析
解析:
暂无解析
相关考题:
You are the network administrator for your company. The network contains a Windows Server 2003 computernamed Server1.Server1 contains two NTFS volumes named Data and Userfiles. The volumes are located on separate hard disks.The Data volume is allocated the drive letter D. The Data volume is shared as \\Server1\Data. The Userfiles volume is mounted on the Data volume as a volume mount point. The Userfiles volume is displayed as the D:\Userfiles folder when you view the local disk drives by using Windows Explorer on Server1. The D:\Userfiles folder is shared as \\Server1\Userfiles.The files on the Userfiles volume change every day. Users frequently ask you to provide them with previous versions of files. You enable and configure Shadow Copies on the Data volume. You schedule shadow copies to be created once a day. Users report that they cannot recover previous versions of files in the \\Server1\Userfiles shared folder.You need to enable users to recover previous versions of files on the Userfiles volume.What should you do? ()
You need to ensure that you can recover system configuration and data if your computer hard disk fails.What should you do?() A.AB.BC.CD.D
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.What should you do?()A.AB.BC.CD.D
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.
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?()A、RECOVERY_PARALLELISMB、FAST_START_MTTR_TARGETC、LOG_CHECKPOINT_INTERVALD、FAST_START_PARALLEL_ROLLBACK
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 type of database file is spread across all disks in a disk group?()A、 All types of files are spread across all disks in the disk group.B、 DatafilesC、 Redo log filesD、 Archived redo log filesE、 Control files
You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number (SCN).
单选题You are the network administrator for your company. The network contains a Windows Server 2003 computernamed Server1.Server1 contains two NTFS volumes named Data and Userfiles. The volumes are located on separate hard disks.The Data volume is allocated the drive letter D. The Data volume is shared as //Server1/Data. The Userfiles volume is mounted on the Data volume as a volume mount point. The Userfiles volume is displayed as the D:/Userfiles folder when you view the local disk drives by using Windows Explorer on Server1. The D:/Userfiles folder is shared as //Server1/Userfiles.The files on the Userfiles volume change every day. Users frequently ask you to provide them with previous versions of files. You enable and configure Shadow Copies on the Data volume. You schedule shadow copies to be created once a day. Users report that they cannot recover previous versions of files in the //Server1/Userfiles shared folder.You need to enable users to recover previous versions of files on the Userfiles volume.What should you do? ()AAssign drive E to Userfiles. Enable Shadow Copies on the Userfiles volume.BConvert the disk that contains the Data volume to a dynamic disk.CConvert the disk that contains the Userfiles volume to a dynamic disk.DInstruct users to connect to //Server1/Data when they attempt to access previous versions of files in the D:/Userfiles folder.EInstruct users to connect to //Server1/D$ when they attempt to access previous versions of files on the Data volume.
单选题When performing an incomplete recover of the whole database, which data files must you restore? ()AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题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?()AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut 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. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?()Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A It will display a list of files that need incremental backupB It will display a list of files that need backup after five daysC It will display a list of files that were backed up in the last five daysD It will display a list of files that have not been backed up in the last five daysE It will apply the current retention policy to determine the files that need to be backed up
多选题Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace
单选题Which type of database file is spread across all disks in a disk group?()A All types of files are spread across all disks in the disk group.B DatafilesC Redo log filesD Archived redo log filesE Control files
多选题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.
单选题You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure, the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files?()AOnly the data files.BAll of the data files and the control files.COnly the data files belonging to the SYSTEM tablespace.DOnly the data files belonging to the SYSTEM tablespace and the control files.
多选题Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number (SCN).
多选题Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure
单选题You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()AIt will display a list of files that need incremental backupBIt will display a list of files that need backup after five daysCIt will display a list of files that were backed up in the last five daysDIt will display a list of files that have not been backed up in the last five daysEIt will apply the current retention policy to determine the files that need to be backed up
单选题You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?()ARECOVERY_PARALLELISMBFAST_START_MTTR_TARGETCLOG_CHECKPOINT_INTERVALDFAST_START_PARALLEL_ROLLBACK
单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?()Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
单选题You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do?()ACreate a System Restore point.BPerform an Automated System Recovery (ASR) backup and restore.CIn the Backup and Restore Center window, click the Back up files button.DIn the Backup and Restore Center window, click the Back up computer button.
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file, just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery
单选题You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE; Which statement is true about executing this command?()A It will display a list of files that need incremental backup.B It will display a list of files that need backup after five days.C It will display a list of files that were backed up in the last five days.D It will display a list of files that have not been backed up in the last five days.E It will apply the current retention policy to determine the files that need to be backed up.