单选题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 b

题目
单选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.

正确答案:A,D

第2题:

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 file
  • B、 the server parameter file
  • C、 the formatted name of a control file autobackup
  • D、 an RMAN session log file
  • E、 the trace file

正确答案:C,D

第3题:

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 set of flags may be specified when enabling trace options

正确答案:A,D

第4题:

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.

正确答案:C

第5题:

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.

正确答案:D

第6题:

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 file
  • B、Location of the control file
  • C、Contents of the control file in text format
  • D、SQL command to re-create the database
  • E、SQL command to re-create the control file
  • F、Contents of the control file in binary format

正确答案:E

第7题:

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()

  • A、 backup pieces
  • B、 copies of all the parameter files
  • C、 trace file generated using BACKUP CONTROLFILE TO TRACE
  • D、 control file autobackups

正确答案:A,D

第8题:

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.

正确答案:D

第9题:

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 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.

正确答案:D

第10题:

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

正确答案:D

更多相关问题