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

题目内容 (请给出正确答案)
单选题
You backed up the control file to trace. Which statement is true about the trace file generated?()
A

The trace file is in binary format.

B

The trace file has a SQL script to re-create the control file.

C

The trace file is a backup set created during the backup of the control file. 

D

The trace file contains the instructions to manually re-create the control file.

E

The trace file is an image copy of the control file created during the backup of the control file.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You backed up the control file to trace. Which statement is true about the trace file generated?()A The trace file is in binary format.B The trace file has a SQL script to re-create the control file.C The trace file is a backup set created during the backup of the control file. D The trace file contains the instructions to manually re-create the control file.E The trace file is an image copy of the control file created during the backup of the control file.” 相关考题
考题 You need to restore some files from a file system. The file system was backed up from a snapshot.  Which command will correctly restore these files?()A、 fssnap -iB、 fssnap -rC、 ufsrestore -iD、 snaprestore -i

考题 You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What does the statement generate?()A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.

考题 You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?()A、 synch catalogB、 resync catalogC、 replicate catalogD、 update catalogE、 restore catalog

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target 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.()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

考题 Which of the following attributes is set when a file is ready to be backed up?()A、aB、hC、rD、s

考题 In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

考题 Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

考题 You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery; status of the tablespace in control file will be changed automatically

考题 You issued the following statement:  SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()  A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.

考题 You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file

考题 You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A、Database Datafiles B、Database Control Files C、Online redo logsD、Archived redo logs E、The database SPFILE F、None of the above, all these files are backed up. 

考题 You performed a backup of the flash recovery area by using the following command for the first time: RMAN BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up?()A、flashback logsB、current control fileC、control file autobackupsD、incremental backup sets

考题 You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement:    SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400;    What is the outcome of this statement? ()A、 The statement will not execute successfully.B、 The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.

考题 多选题You performed a backup of the flash recovery area by using the following command for the first time: RMAN BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up?()Aflashback logsBcurrent control fileCcontrol file autobackupsDincremental backup sets

考题 单选题In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A  to configure RMAN to maintain backup information in the RMAN repository for seven daysB  to configure RMAN to maintain backup information in the control file for at least seven daysC  to display the list of files that have not been backed up for the last seven daysD  to display the list of files that must be backed up within seven days

考题 单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A Start the instance and open the database, instance recovery automatically recovers control files B Create a file based on the contents of the trace file and save it to the control file locations and start the database C Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 单选题You need to restore some files from a file system. The file system was backed up from a snapshot.  Which command will correctly restore these files?()A  fssnap -iB  fssnap -rC  ufsrestore -iD  snaprestore -i

考题 单选题You backed up the control file to trace. Which statement is true about the trace file generated?()A The trace file is in binary format.B The trace file has a SQL script to re-create the control file.C The trace file is a backup set created during the backup of the control file. D The trace file contains the instructions to manually re-create the control file.E The trace file is an image copy of the control file created during the backup of the control file.

考题 单选题Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()A only the control file, the current SPFILE, and data filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file, current SPFILE file, data files, and archived redo logs

考题 单选题You issued the following statement:  SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What will be the result of issuing the statement?()A  The control file will be multiplexed.B  The control file will be recreated.C The script containing the CREATE CONTROLFILE statement will be created.D  The binary backup of the control file will be created.

考题 多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()AA tablespace is taken offline.BThe database instance is restarted.CA new data file is added to an existing tablespace.DA successful backup is recorded in the RMAN repository.EThe RMAN connection is disconnected from the target database.

考题 单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()A Database Datafiles B Database Control Files C Online redo logsD Archived redo logs E The database SPFILE F None of the above, all these files are backed up. 

考题 单选题You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?()A  synch catalogB  resync catalogC  replicate catalogD  update catalogE  restore catalog

考题 单选题You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A DatafilesB  Current control fileC  Server parameter file (spfile)D  Password file

考题 多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

考题 单选题You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  What does the statement generate?()A A text copy of the control file.B A binary copy of the control file.C A file containing a SQL statement which will re-create the database.D A file containing a SQL statement which will re-create the control file.

考题 单选题Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified?()A  only the control file, the current SPFILE, and data filesB  only the current SPFILE and data files if autobackup is disabledC  only the data files and the archived redo logsD  the control file,current SPFILE file,data files,and archived redo logs