1Z0-060

多选题Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）AReduced logical I/OBReduced virtual memory utilizationCImproved parallel Execution performanceDImproved Serial Execution perform

题目
多选题
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）
A

Reduced logical I/O

B

Reduced virtual memory utilization

C

Improved parallel Execution performance

D

Improved Serial Execution performance

E

Reduced physical I/O

F

Reduced CPU utilization

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

第1题：

Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()

A. Maximum Undo per consumer group

B. Maximum Idle time

C. Parallel server limit

D. CPU

E. Exadata I/O

F. Local file system I/O


参考答案：C, D, F

第2题：

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?()

A. Reduced logical I/O

B. Reduced virtual memory utilization

C. Improved parallel Execution performance

D. Improved Serial Execution performance

E. Reduced physical I/O

F. Reduced CPU utilization


参考答案：B, C, F

第3题：

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

A.Every SQL statement in the STS is considered only once for execution

B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

C.The execution plan and execution statistics are computed for each SQL statement in the STS

D.The effects of DDL and DML are considered to produce the execution plan and execution statistics


参考答案：A, C

第4题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

  • A、 It must be executed from the Oracle Database 11g environment.
  • B、 It must be executed only after the SYSAUX tablespace has been created.
  • C、 It must be executed from the environment of the database that is being upgraded.
  • D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
  • E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

正确答案:C

第5题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

  • A、It must be executed from the Oracle Database 11g environment.
  • B、It must be executed only after the SYSAUX tablespace has been created.
  • C、It must be executed from the environment of the database that is being upgraded.
  • D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
  • E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

正确答案:C

第6题：

Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?()

A. Thread creation must be routed through a dispatcher process

B. The local listener may spawn a now process and have that new process create a thread

C. Each Oracle process runs an SCMN thread.

D. Each multithreaded Oracle process has an SCMN thread.

E. The local listener may pass the request to an existing process which in turn will create a thread.


参考答案：A, D, E

第7题：

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）

  • A、Reduced logical I/O
  • B、Reduced virtual memory utilization
  • C、Improved parallel Execution performance
  • D、Improved Serial Execution performance
  • E、Reduced physical I/O
  • F、Reduced CPU utilization

正确答案:B,C,F

第8题：

Which three statements are true about Oracle Data Pump export and import operations?()

A. You can detach from a data pump export job and reattach later.

B. Data pump uses parallel execution server processes to implement parallel import.

C. Data pump import requires the import file to be in a directory owned by the oracle owner.

D. The master table is the last object to be exported by the data pump.

E. You can detach from a data pump import job and reattach later.


参考答案：A, B, D

第9题：

In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

  • A、 Recovery catalog
  • B、 Oracle Enterprise Manager Repository
  • C、 Automatic Workload Repository （AWR）
  • D、 Oracle 10g Enterprise Manager Grid Control
  • E、 Automatic Database Diagnostic Monitor （ADDM）

正确答案:C

第10题：

You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）

  • A、Oracle Management Agent
  • B、Enterprise Manager with Grid Control
  • C、Enterprise Manager with Database Control
  • D、Operating System Socket for incoming requests
  • E、Real Application Cluster （RAC） with three instances
  • F、Enterprise Manager with Generic Database Management

正确答案:A

更多相关问题
相关内容