多选题Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）AMaximum Undo per consumer groupBMaximum Idle timeCParallel server l

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

相似考题

1.View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

2.Which three statements are true about using flashback database in a multitenant container database(CDB)?()A. The root container can be flashed back without flashing back the pluggable databases (PDBs).B. To enable flashback database, the CDB must be mounted.C. Individual PDBs can be flashed back without flashing back the entire cdb.D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

3.Which two are true concerning a multitenant container database with three pluggable database?()A. All administration tasks must be done to a specific pluggable database.B. The pluggable databases increase patching time.C. The pluggable databases reduce administration effort.D. The pluggable databases are patched together.E. Pluggable databases are only used for database consolidation.

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

更多“多选题Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）AMaximum Undo per consumer groupBMaximum Idle timeCParallel server l”相关问题

  • 第1题：

    Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）

    A. Mount the container database (CDB) and restore the control file from the control file auto backup.

    B. Recover and open the CDB in NORMAL mode.

    C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

    D. Open all the pluggable databases.

    E. Recover each pluggable database.

    F. Start the database instance in the nomount stage and restore the control file from control file auto backup.


    参考答案：C, D, F

  • 第2题：

    Which of these represent the main components of Database Resource Manager？（）

    • A、 Resource consumer groups
    • B、 Resource plans
    • C、 Resource-plan groups
    • D、 Resource-plan directives
    • E、 All of the above

    正确答案:A,B,D

  • 第3题：

    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

  • 第4题：

    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

    • A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
    • B、In a PDB plan, subplans may be used with up to eight consumer groups.
    • C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
    • D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
    • E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

    正确答案:A,B,C,D,E

  • 第5题：

    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

    • A、 CPU usage
    • B、 degree of parallelism
    • C、 number of open cursors
    • D、 number of sorts performed
    • E、 idle time for blocking sessions
    • F、 number of disk I/O operations performed
    • G、 number of memory I/O operations performed

    正确答案:A,B,E

  • 第6题：

    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

  • 第7题：

    多选题
    Which of these represent the main components of Database Resource Manager？（）
    A

    Resource consumer groups

    B

    Resource plans

    C

    Resource-plan groups

    D

    Resource-plan directives

    E

    All of the above


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

  • 第8题：

    多选题
    Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）
    A

    SWITCH_TIME

    B

    SWITCH_GROUP

    C

    MAX_SESS_POOL

    D

    SWITCH_ESTIMATE


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

  • 第9题：

    多选题
    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


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

  • 第10题：

    单选题
    You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）
    A

    The Resource Manager plan does not affect the user.

    B

    There must be a plan directive in any of the plans of the group to control the resources.

    C

    The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.

    D

    The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.

    E

    The members of this group can change their group without the database administrator’s intervention.


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

  • 第11题：

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

  • 第12题：

    多选题
    In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager？（）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


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

  • 第13题：

    Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

    • A、The root container can be flashed back without flashing back the pluggable databases (PDBs).
    • B、To enable flashback database, the CDB must be mounted.
    • C、Individual PDBs can be flashed back without flashing back the entire cdb.
    • D、The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
    • E、A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

    正确答案:B,C,D

  • 第14题：

    You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan？（）

    • A、assign users to consumer groups
    • B、set the resource plan for the instance
    • C、configure a simple resource plan and specify plan directives
    • D、configure a complex resource plan and specify plan directives

    正确答案:B

  • 第15题：

    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

  • 第16题：

    Which two are true concerning a multitenant container database with three pluggable database?（）

    • A、All administration tasks must be done to a specific pluggable database.
    • B、The pluggable databases increase patching time.
    • C、The pluggable databases reduce administration effort.
    • D、The pluggable databases are patched together.
    • E、Pluggable databases are only used for database consolidation.

    正确答案:C,D,E

  • 第17题：

    In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

    • A、CPU usage
    • B、degree of parallelism
    • C、number of open cursors
    • D、number of sorts performed
    • E、idle time for blocking sessions
    • F、number of disk I/O operations performed
    • G、number of memory I/O operations performed

    正确答案:A,B,E

  • 第18题：

    多选题
    Identify two correct statements about multitenant architectures.（）
    A

    Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.

    B

    Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.

    C

    Multiple CDBs share certain PDB resources.

    D

    Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.

    E

    Patches are always applied at the CDB level.

    F

    A PDB can have a private undo tablespace.


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

  • 第19题：

    多选题
    Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）
    A

    Mount the container database (CDB) and restore the control file from the control file auto backup.

    B

    Recover and open the CDB in NORMAL mode.

    C

    Mount the CDB and then recover and open the database, with the RESETLOGS option.

    D

    Open all the pluggable databases.

    E

    Recover each pluggable database.

    F

    Start the database instance in the nomount stage and restore the control file from control file auto backup.


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

  • 第20题：

    单选题
    You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
    A

     assign users to consumer groups

    B

     set the resource plan for the instance

    C

     configure a simple resource plan and specify plan directives

    D

     configure a complex resource plan and specify plan directives


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

  • 第21题：

    多选题
    Which two are true concerning a multitenant container database with three pluggable database?（）
    A

    All administration tasks must be done to a specific pluggable database.

    B

    The pluggable databases increase patching time.

    C

    The pluggable databases reduce administration effort.

    D

    The pluggable databases are patched together.

    E

    Pluggable databases are only used for database consolidation.


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

  • 第22题：

    多选题
    Which three statements are true about using flashback database in a multitenant container database(CDB)?（）
    A

    The root container can be flashed back without flashing back the pluggable databases (PDBs).

    B

    To enable flashback database, the CDB must be mounted.

    C

    Individual PDBs can be flashed back without flashing back the entire cdb.

    D

    The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.

    E

    A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.


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

  • 第23题：

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


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

  • 第24题：

    多选题
    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）
    A

    If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.

    B

    In a PDB plan, subplans may be used with up to eight consumer groups.

    C

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.

    D

    If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

    E

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.


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

相关内容