单选题You backed up the control file to trace. Which statement is true about the trace file generated?()AThe trace file is in binary format.BThe trace file has a SQL script to re-create the control file.CThe trace file is a backup set created during the backup of the control file. DThe trace file contains the instructions to manually re-create the control file.EThe 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.
参考解析
解析:
暂无解析
相关考题:
Which two statements are true regarding trace options on Junos devices?()A、You can see the contents of the log file by entering the show log filename commandB、Trace options will send information to your screen automaticallyC、Trace options are limited to one protocol at a timeD、The file name and set of flags may be specified when enabling trace options
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.
Which two statements are true regarding trace options on Junos devices?()A、You can see the contents of the log file by entering the show log filename command.B、Trace options will send information to your screen automatically.C、Trace options are limited to one protocol at a time.D、The file name and a set of flags may be specified when enabling traceoptions.
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 connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? ()A、 the alert log fileB、 the server parameter fileC、 the formatted name of a control file autobackupD、 an RMAN session log fileE、 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、 copies of all the parameter filesC、 trace file generated using BACKUP CONTROLFILE TO TRACED、 control file autobackups
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process?() A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
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 scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script
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
You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking 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?()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
You are the network administrator for The network is distributed across five countries in Europe, namely Spain, Italy, Hungary, Austria, and Germany. All network servers run Windows Server 2003. Each location has three print servers. You need to monitor usage of print queues on all print servers on the network. You plan to enable monitoring for each print server in the same way. Monitoring data must be stored in a central location and archived for five years to enable data comparison. What should you do?()A、Create a counter log and specify SQL Database as the log file type.B、Create a trace log and specify Circular Trace File as the log file type.C、Create a counter log and specify Binary Circular File as the log file type.D、Create a trace log and specify Sequential Trace File as the log file type.
单选题You backed up the control file to trace. Which statement is true about the trace file generated?()AThe trace file is in binary format.BThe trace file has a SQL script to re-create the control file.CThe trace file is a backup set created during the backup of the control file. DThe trace file contains the instructions to manually re-create the control file.EThe 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?()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.
单选题You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process?()A Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.B Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.C Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.D Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
单选题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 configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()Abackup piecesBcontrol file autobackupsCcopies of all the parameter filesDtrace file generated using BACKUP CONTROLFILE TO TRACE
单选题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 are the network administrator for The network is distributed across five countries in Europe, namely Spain, Italy, Hungary, Austria, and Germany. All network servers run Windows Server 2003. Each location has three print servers. You need to monitor usage of print queues on all print servers on the network. You plan to enable monitoring for each print server in the same way. Monitoring data must be stored in a central location and archived for five years to enable data comparison. What should you do?()ACreate a counter log and specify SQL Database as the log file type.BCreate a trace log and specify Circular Trace File as the log file type.CCreate a counter log and specify Binary Circular File as the log file type.DCreate a trace log and specify Sequential Trace File as the log file type.
单选题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 received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()Athe alert log file and the trace filesB the redo log filesC the control fileD the change tracking 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