单选题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？（）AUSER_DUMP_DESTBCORE_DUMP_DESTCTRACE_DUMP_DESTDBACKUP_DUMP_DESTEBACKGROUND_DUMP_DEST
单选题
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_DEST
B
CORE_DUMP_DEST
C
TRACE_DUMP_DEST
D
BACKUP_DUMP_DEST
E
BACKGROUND_DUMP_DEST
参考解析
解析：
暂无解析
相关考题：
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 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 configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）A、 backup piecesB、 copies of all the parameter filesC、 trace file generated using BACKUP CONTROLFILE TO TRACED、 control file autobackups
You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filenameB、Make a copy of the control file with the database shut downC、Issue ALTER DATABASE BACKUP CONTROLFILE TO traceD、Make a copy of the control file with the database still running
You work as a database administrator for Supportcenter.cn. 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 recoverscontrol filesB、Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC、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 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 work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file？（）A、USER_DUMP_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
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 command will result in a trace file being created with the create controlfile command contained in it？（） A、 alter database backup controlfileB、 alter database backup controlfile to traceC、 alter database controlfile backupD、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E、 alter database begin controlfile backup
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 configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）A、backup piecesB、control file autobackupsC、copies of all the parameter filesD、trace file generated using BACKUP CONTROLFILE TO TRACE
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup 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 are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A Start the database in the MOUNT stage.B Back up the control file to trace.C Set the DBIDD Issue the RECOVER DATABASE command.
单选题ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）AIssue ALTER DATABASE BACKUP CONTROLFILE TO filenameBMake a copy of the control file with the database shut downCIssue ALTER DATABASE BACKUP CONTROLFILE TO traceDMake a copy of the control file with the database still running
单选题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 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？（）AUSER_DUMP_DESTBCORE_DUMP_DESTCTRACE_DUMP_DESTDBACKUP_DUMP_DESTEBACKGROUND_DUMP_DEST
单选题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？（）AImage of the control fileBLocation of the control fileCContents of the control file in text formatDSQL command to re-create the databaseESQL command to re-create the control fileFContents of the control file in binary format
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）AA text copy of the control file.BA binary copy of the control file.CA file containing a SQL statement which will re-create the database.DA file containing a SQL statement which will re-create the control file.
单选题Which command will result in a trace file being created with the create controlfile command contained in it？（）A alter database backup controlfileB alter database backup controlfile to traceC alter database controlfile backupD alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E alter database begin controlfile backup
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
单选题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.CThe script containing the CREATE CONTROLFILE statement will be created.D The binary backup of the control file will be created.
单选题You work as a database administrator for Supportcenter.cn. 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？（）AStart the instance and open the database， instance recovery automatically recoverscontrol filesBCreate a file based on the contents of the trace file and save it to the control file locations and start the databaseCRe-create the database （The recovery of the control file is not possible because you have lost all the control files.）DStart the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.EStart the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题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？（）AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command