网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which is not a valid way of backing up a control file？（）
A
Backing up the control file to trace
B
Copying the existing control file of the database to the backup location during a hot backup
C
Copying the existing control file of the database to the backup location during a cold backup
D
Creating a backup control file
E
Using the create controlfile command
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which is not a valid way of backing up a control file？（）A Backing up the control file to traceB Copying the existing control file of the database to the backup location during a hot backup C Copying the existing control file of the database to the backup location during a cold backupD Creating a backup control fileE Using the create controlfile command” 相关考题
考题
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（） A、 Restore and recover the datafile.B、 Restore and recover the tablespace.C、 Restore and recover the database.D、 Restore and recover the control file.E、 Restore and recover the parameter file.
考题
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.
考题
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.
考题
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
考题
When configuring the messaging system， which of the following are valid parameters for the file transport？ （）A、File NameB、Operating SystemC、LocationD、HostE、Mode
考题
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
考题
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.
考题
Which two statements regarding the control file and Recover Manager are true？ （）A、The control file can grow in size.B、The control file can store RMAN scripts.C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.D、The RMAN catalog can exist solely in the control file of the target database.
考题
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
考题
Which is not a valid way of backing up a control file？（） A、 Backing up the control file to traceB、 Copying the existing control file of the database to the backup location during a hot backup C、 Copying the existing control file of the database to the backup location during a cold backupD、 Creating a backup control fileE、 Using the create controlfile command
考题
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
考题
单选题Before performing a mksysb system backup, which of the following procedures should a system administrator perform to avoid backing up certain user files?（）A
Add the list of files to /etc/exclude.rootvg.B
Modify the image.data file and add the files to be excluded form the backup.C
Modify the bosinst.data file and specify which files are to be excluded from the backup.D
Specify the files to be excluded on the command line when executing the mksysb command.
考题
单选题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 executed the following command to back up your control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； Which initialization parameter is used to specify the location of the trace file？（）A
USER_DUMP_DESTB
CORE_DUMP_DESTC
TRACE_DUMP_DESTD
BACKUP_DUMP_DESTE
BACKGROUND_DUMP_DEST
考题
单选题Which is not a valid way of backing up a control file？（）A
Backing up the control file to traceB
Copying the existing control file of the database to the backup location during a hot backup C
Copying the existing control file of the database to the backup location during a cold backupD
Creating a backup control fileE
Using the create controlfile command
考题
单选题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
考题
单选题After you back up /export using a file system snapshot， and you have removed the snapshot， you also need to remove the backing store. If the snapshot was created with： # mkdir /var/tmp/backup-snaps # fssnap -o bs=/var/tmp/backup-snaps /export Which file do you need to remove？ （）A
AB
BC
CD
D
考题
单选题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 lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）A
Restore and recover the datafile. B
Restore and recover the tablespace. C
Restore and recover the database. D
Restore and recover the control file. E
Restore and recover the parameter file.
考题
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）A
Restore the latest whole backup, perform complete recovery, and open the database normallyB
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
考题
单选题Which of the following backup methodologies is MOST time efficient for backing up data？（）A
IncrementalB
SnapshotC
DifferentialD
GFS
考题
单选题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 work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）A
Shut down the instance， copy the control file to the third location and open the database.B
Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.C
Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.D
Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.E
Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the 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
考题
单选题You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A
Image of the control fileB
Location of the control fileC
Contents of the control file in text formatD
SQL command to re-create the databaseE
SQL command to re-create the control fileF
Contents of the control file in binary format
热门标签
最新试卷
