违法和不良信息举报 联系客服
免费注册 登录

Which command will result in a trace file being created with

题目
单选题
Which command will result in a trace file being created with the create controlfile command contained in it？（）
A

 alter database backup controlfile

B

 alter database backup controlfile to trace

C

 alter database controlfile backup

D

 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’

E

 alter database begin controlfile backup

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

第1题：

A file named "core" exists in the current directory.  Which of the following commands should be used to determine what created the "core" file?（）

  • A、 dump -t core 
  • B、 strings core 
  • C、 trace -a core 
  • D、 crash core /unix_up

正确答案:B

第2题：

Which of the following will occur if an operator types the command vi file.out?（）

  • A、If the file exists it will be opened for editing. If the file does not exist an error message will be displayed.
  • B、If the file exists it will be opened for editing. If the file does not exist a new file with the name file.out will be created and opened for editing.
  • C、If the file exists an error message will be displayed. If the file does not exist a new file with the name file.out will be created and opened for editing.
  • D、If the file exists the operator will be asked whether to open the file or overwrite the file. If the file does not exist a new file with the name file.out will be created and opened for editing.

正确答案:B

第3题：

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’);The possible outcome and actions to aggregate the trace files are as follows:1. The command fails because a module name is not specified.2. A trace file is created for each session that is running the SRV1 service.3. An aggregated trace file is created for all the sessions that are running the SRV1 service.4. The trace files may be aggregated by using the trcess utility.5. The trace files be aggregated by using the tkprof utility.Identify the correct outcome and the step to aggregate by using tkprof utility?（）

A. 1

B. 2 and 4

C. 2 and 5

D. 3 and 4

E. 3 and 5


参考答案：B

第4题：

The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）

  • A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
  • B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
  • C、 Issue the SERVICES command at the LSNRCTL> prompt.
  • D、 Issue the STATUS command at the LSNRCTL> prompt.

正确答案:D

第5题：

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

第6题：

Which command will debug the AIX kernel？（）

  • A、kdb
  • B、snap
  • C、truss
  • D、trace

正确答案:A

第7题：

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

第8题：

Which of the following dbx commands should be used to obtain a stack trace from a coredump file?（）

  • A、trace 
  • B、where 
  • C、status 
  • D、which

正确答案:B

第9题：

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

第10题：

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

正确答案:A

更多相关问题
相关内容