网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “多选题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 incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.” 相关考题
考题 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.

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

考题 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).

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

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

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

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

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

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

考题 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).

考题 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 SRB、The incident files and dumps are not retained in the ADR for the manually created incidentsC、The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD、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

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

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

考题 多选题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 incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.

考题 多选题Which  statements regarding the server parameter file (SPFILE) are true()AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server, but it is not written to by the server.FAn SPFILE must be created manually, before creating a database, even if you use the DatabaseConfiguration Assistant (DBCA) to create the database

考题 多选题Which statements are true regarding the creation of an incident package file by using the EM Workbench Support?()AYou can add or remove the trace files to the package.BYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.CYou can add SQL test cases to the incident package.DYou cannot create an incremental incident package when the physical files are purged rom the ADR.

考题 多选题Which two statements are true regarding trace options on Junos devices?()AYou can see the contents of the log file by entering the show log filename command.BTrace options will send information to your screen automatically.CTrace options are limited to one protocol at a time.DThe file name and a set of flags may be specified when enabling traceoptions.

考题 多选题Which two statements are true regarding the Oracle Data Pump export and import operations()AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported.

考题 多选题Which two statements are true regarding a PL/SQL package body?()AIt cannot be created without a package specification.BIt cannot invoke subprograms defined in other packages.CIt can contain only the subprograms defined in the package specification.DIt can be changed and recompiled without making the package specification invalid.

考题 多选题Which two statements regarding a SQL profile are true?()AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.

考题 多选题Which two statements are true regarding the usage of the SQL*Loader utility()AYou can load data into multiple tables during the same load session.BYou can load data from multiple files to a table during the same load session.CYou cannot perform selective data loading based on the values available in the records.DYou can use an export file generated by the EXPDP utility as an input data file to load the data.EYou can load data only if the input file is available on the disk and tape but not in a named pipes.

考题 多选题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?()AUse Oracle Managed Files (OMF).BSpecify the SEED FILE_NAME_CONVERT clause.CSpecify the PDB_FILE_NAME_CONVERT initialization parameter.DSpecify the DB_FILE_NAMECONVERT initialization parameter.ESpecify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

考题 多选题Which two statements are true regarding the SQL Repair Advisor?()AThe SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.BThe SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.CThe SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.DThe 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.

考题 多选题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?()AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.

考题 多选题Which  statements are true regarding the Oracle Data Pump export and import operations()AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported

考题 多选题Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support()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 incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

考题 多选题Which two statements are true regarding trace options on Junos devices?()AYou can see the contents of the log file by entering the show log filename commandBTrace options will send information to your screen automaticallyCTrace options are limited to one protocol at a timeDThe file name and set of flags may be specified when enabling trace options