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

题目
单选题
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.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. 1B. 2 and 4C. 2 and 5D. 3 and 4E. 3 and 5

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

3.Which command will debug the AIX kernel？（）A、kdbB、snapC、trussD、trace

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

更多“Which command will result in a trace file being created with”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

    正确答案:B

  • 第5题：

    Which two outcomes result when a domain is created in development mode?（）

    • A、WebLogic server starts automatically upon the restarting of the machine
    • B、each new cluster will automatically be created with two managed servers
    • C、boot.properties file automatically stored  
    • D、creation of an auto deploy folder used for the application to deploy automatically
    • E、Node Manager will be automatically configured

    正确答案:C,D

  • 第6题：

    单选题
    You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）
    A

    When a file is created in DGROUP1 with the template， it would have three­way mirroring. 

    B

    When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

    C

    When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping.

    D

    When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping.

    E

    When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

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


    正确答案： A
    解析： 暂无解析

  • 第9题：

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


    正确答案： E
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
    A

    None of the data definition language (DDL) statements are logged in the trace file.

    B

    Only DDL commands that resulted in errors are logged in the alert log file.

    C

    A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

    D

    Only DDL commands that resulted in the creation of new database files are logged.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

    正确答案:D

  • 第17题：

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


    正确答案： C
    解析： 暂无解析

  • 第18题：

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


    正确答案： B
    解析： 暂无解析

  • 第19题：

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’；   Which two statements are true regarding the backup created using this command？（）
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


    正确答案： C,E
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

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


    正确答案： D
    解析： 暂无解析

  • 第22题：

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


    正确答案： E
    解析： 暂无解析

  • 第23题：

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


    正确答案： A
    解析： 暂无解析

  • 第24题：

    多选题
    Which two outcomes result when a domain is created in development mode?（）
    A

    WebLogic server starts automatically upon the restarting of the machine

    B

    each new cluster will automatically be created with two managed servers

    C

    boot.properties file automatically stored

    D

    creation of an auto deploy folder used for the application to deploy automatically

    E

    Node Manager will be automatically configured


    正确答案： E,A
    解析： 暂无解析

相关内容