itgle.com

多选题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.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 executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics

2.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 groupB. Maximum Idle timeC. Parallel server limitD. CPUE. Exadata I/OF. Local file system I/O

3.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 processB. The local listener may spawn a now process and have that new process create a threadC. 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.

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

参考答案和解析
正确答案： E,D
解析： 暂无解析
更多“多选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）

    • A、The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
    • B、The optimizer can re optimize a query only once using cardinality feedback.
    • C、The optimizer enables monitoring for cardinality feedback after the first execution of a query.
    • D、The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
    • E、After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

    正确答案:A,C,D

  • 第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题：

    多选题
    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,B
    解析： 暂无解析

  • 第8题：

    多选题
    You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)
    A

    Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.

    B

    A resumable statement is suspended only if an out of space error occurs.

    C

    When a resumable statement is suspended, the transaction that contains the statement is also suspended.

    D

    A resumable statement can only be suspended and resumed once during the execution of the statement.

    E

    You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session


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

  • 第9题：

    多选题
    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,D
    解析： 暂无解析

  • 第10题：

    多选题
    Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）
    A

    SWITCH_TIME

    B

    SWITCH_GROUP

    C

    MAX_SESS_POOL

    D

    SWITCH_ESTIMATE


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

  • 第11题：

    多选题
    Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）
    A

    The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

    B

    The optimizer can re optimize a query only once using cardinality feedback.

    C

    The optimizer enables monitoring for cardinality feedback after the first execution of a query.

    D

    The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

    E

    After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.


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

  • 第12题：

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


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    多选题
    The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it used threads instead of processes.  What are thee kinds of threads that it uses？（）
    A

    TCP

    B

    Task

    C

    Monitor

    D

    Dispatcher

    E

    Shared Server

    F

    Shutdown address


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

  • 第20题：

    多选题
    Which three statements are true about logical structures of the Oracle database（）
    A

    Each segment contains one or more extents.

    B

    Multiple tablespaces can share a single data file.

    C

    A data block is the smallest unit of input/output （I/O） in data files.

    D

    It is possible to have tablespaces of different block sizes in a database.

    E

    Each data block in the database always corresponds to one operating system block.


    正确答案： A,C,D
    解析： A答案：每个段包含一个或多个区，正确。 
    B答案：一个数据文件只能属于一个表空间，故错误。 
    C答案：Oracle data block是最小的I/O单位，正确 
    D答案：可以是不同的块大小，需要指名非标准块的位置。 
    E答案：每个数据库里面的数据库对应一个或多个操作系统块，故E错误。

  • 第21题：

    多选题
    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,C
    解析： 暂无解析

  • 第22题：

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

  • 第23题：

    多选题
    Identify four uses of the Oracle Scheduler.（）
    A

    enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment

    B

    enables Oracle database to do patches according to a DBA-defined schedule

    C

    enables you to schedule the execution of jobs based on time

    D

    enables you to execute jobs in a clustered environment

    E

    enables you to periodically execute operating systemscript files located on the same server as the database

    F

    enables you to create a job that makes use of saved programs and schedules

    G

    enables you to automate the management of the jobs that are created using the DBMS_JOB package


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

相关内容