多选题Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental i

题目
多选题
Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）
A

You can add SQL test cases to the incident package.

B

You can add or remove the trace files to the package.

C

You cannot create an incremental incident package when the physical files are purged from the ADR.

D

You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.

相似考题

1.Which two statements regarding a SQL profile are true?()A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command.

2.You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

3.Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）A、 You can add or remove the trace files to the package.B、 You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.C、 You can add SQL test cases to the incident package.D、 You cannot create an incremental incident package when the physical files are purged rom the ADR.

4.Which two statements are true regarding the SQL Repair Advisor?()A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

更多“多选题Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental i”相关问题

  • 第1题：

    Which two statements are true regarding the SQL Repair Advisor？（） 

    • A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
    • B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
    • C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
    • D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

    正确答案:B,D

  • 第2题：

    Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support（）

    • A、You can add SQL test cases to the incident package.
    • B、You can add or remove the trace files to the package.
    • C、You cannot create an incremental incident package when the physical files are purged from the ADR.
    • D、You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

    正确答案:A,B,D

  • 第3题：

    Which two statements regarding a SQL profile are true？（）

    • A、 It is built by Automatic Tuning Optimizer.
    • B、 It cannot be stored persistently in the data dictionary.
    • C、 It can be used by the query optimizer automatically.
    • D、 It can be created manually by using the CREATE PROFILE command.

    正确答案:A,C

  • 第4题：

    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

    • A、Use Oracle Managed Files (OMF).
    • B、Specify the SEED FILE_NAME_CONVERT clause.
    • C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
    • D、Specify the DB_FILE_NAMECONVERT initialization parameter.
    • E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

    正确答案:A,B,C

  • 第5题：

    Which two statements are true regarding the usage of the SQL*Loader utility（）

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第6题：

    多选题
    Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）
    A

    You can add SQL test cases to the incident package.

    B

    You can add or remove the trace files to the package.

    C

    You cannot create an incremental incident package when the physical files are purged from the ADR.

    D

    You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.


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

  • 第7题：

    多选题
    Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）
    A

    You can add or remove the trace files to the package.

    B

    You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

    C

    You can add SQL test cases to the incident package.

    D

    You cannot create an incremental incident package when the physical files are purged rom the ADR.


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

  • 第8题：

    多选题
    Which two statements are true regarding the Oracle Data Pump export and import operations（）
    A

    You cannot export data from a remote database.

    B

    You can rename tables during an import operation.

    C

    You can overwrite existing dump files during an export operation.

    D

    You can compress the data during export but not the metadata because it is not supported.


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

  • 第9题：

    多选题
    Which two statements regarding a SQL profile are true？（）
    A

    It is built by Automatic Tuning Optimizer.

    B

    It cannot be stored persistently in the data dictionary.

    C

    It can be used by the query optimizer automatically.

    D

    It can be created manually by using the CREATE PROFILE command.


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

  • 第10题：

    多选题
    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）
    A

    Use Oracle Managed Files (OMF).

    B

    Specify the SEED FILE_NAME_CONVERT clause.

    C

    Specify the PDB_FILE_NAME_CONVERT initialization parameter.

    D

    Specify the DB_FILE_NAMECONVERT initialization parameter.

    E

    Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).


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

  • 第11题：

    多选题
    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）
    A

    The tablespace has two data files.

    B

    An error is reported and tablespace creation fails.

    C

    Data files are created with names generated by the instance.

    D

    The tablespace can be extended without specifying the data file.

    E

    Data files belonging to the USERS tablespace cannot be renamed.


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

  • 第12题：

    多选题
    Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support（）
    A

    You can add SQL test cases to the incident package.

    B

    You can add or remove the trace files to the package.

    C

    You cannot create an incremental incident package when the physical files are purged from the ADR.

    D

    You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.


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

  • 第13题：

    Which two statements are true regarding a PL/SQL package body？（）

    • A、It cannot be created without a package specification.
    • B、It cannot invoke subprograms defined in other packages.
    • C、It can contain only the subprograms defined in the package specification.
    • D、It can be changed and recompiled without making the package specification invalid.

    正确答案:A,D

  • 第14题：

    Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）

    • A、You can add SQL test cases to the incident package.
    • B、You can add or remove the trace files to the package.
    • C、You cannot create an incremental incident package when the physical files are purged from the ADR.
    • D、You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.

    正确答案:A,B,D

  • 第15题：

    Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）

    • A、By default, EM express is available for a database after database creation.
    • B、You can use EM express to manage multiple databases running on the same server.
    • C、You can perform basic administrative tasks for pluggable databases by using the EM express interface.
    • D、You cannot start up or shut down a database Instance by using EM express.
    • E、You can create and configure pluggable databases by using EM express.

    正确答案:D

  • 第16题：

    Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）

    • A、The incident metadata is purged when the problem is resolved and the DBA closes the SR
    • B、The incident files and dumps are not retained in the ADR for the manually created incidents
    • C、The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
    • D、The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month

    正确答案:D

  • 第17题：

    View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

    • A、The tablespace has two data files.
    • B、An error is reported and tablespace creation fails.
    • C、Data files are created with names generated by the instance.
    • D、The tablespace can be extended without specifying the data file.
    • E、Data files belonging to the USERS tablespace cannot be renamed.

    正确答案:C,D

  • 第18题：

    多选题
    Which  statements regarding the server parameter file （SPFILE） are true（）
    A

    An SPFILE is a binary file.

    B

    An SPFILE cannot reside on a client.

    C

    An SPFILE cannot contain static parameters.

    D

    An SPFILE can store changes persistently across instance restarts.

    E

    An SPFILE can be read by the database server， but it is not written to by the server.

    F

    An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database


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

  • 第19题：

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


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

  • 第20题：

    多选题
    Which two statements are true regarding a PL/SQL package body？（）
    A

    It cannot be created without a package specification.

    B

    It cannot invoke subprograms defined in other packages.

    C

    It can contain only the subprograms defined in the package specification.

    D

    It can be changed and recompiled without making the package specification invalid.


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

  • 第21题：

    多选题
    Which two statements are true regarding the usage of the SQL*Loader utility（）
    A

    You can load data into multiple tables during the same load session.

    B

    You can load data from multiple files to a table during the same load session.

    C

    You cannot perform selective data loading based on the values available in the records.

    D

    You can use an export file generated by the EXPDP utility as an input data file to load the data.

    E

    You can load data only if the input file is available on the disk and tape but not in a named pipes.


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

  • 第22题：

    多选题
    Which two statements are true regarding the SQL Repair Advisor？（）
    A

    The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

    B

    The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

    C

    The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

    D

    The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.


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

  • 第23题：

    多选题
    Which  statements are true regarding the Oracle Data Pump export and import operations（）
    A

    You cannot export data from a remote database.

    B

    You can rename tables during an import operation.

    C

    You can overwrite existing dump files during an export operation.

    D

    You can compress the data during export but not the metadata because it is not supported


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

  • 第24题：

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


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

相关内容