多选题You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUME

题目
多选题
You execute the following command to create two consumer groups， FIN_GROUP1 and PAY_GROUP1 for a plan， PROD_PLAN：  BEGIN  DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （SIMPLE_PLAN =>’prod_plan’，  CONSUMER_GROUP1 => ’fin_group1’，  GROUP1_CPU => 80，  CONSUMER_GROUP2 => ’pay_group1’，  GROUP2_CPU => 20）；  END；  Which three statements are true？ （）
A

SYS_GROUP gets 100% CPU resources at level 1.

B

FIN_GROUP1 gets 80% CPU resources at level 1.

C

FIN_GROUP1 gets 80% CPU resources at level 2.

D

PAY_GROUP1 gets 20% CPU resources at level 1.

E

PAY_GROUP1 gets 20% CPU resources at level 2.

F

OTHER_GROUP gets 100% CPU resources at level 1.

G

OTHER_GROUP gets 100% CPU resources at level 2.

相似考题

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. Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C、The command will, create a common user whose description is contained in the root and each pdb.D、The schema for the common user C # # A_ADMIN can be different in each container.E、The command will create a user in the root container only because the container clause is not used

3. You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

4.You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）A. one-wayB. two-wayC. three-wayD. No handshakes required during authenticationE. None of the above

参考答案和解析
正确答案： G,D
解析： 暂无解析
更多“You execute the following command to create two consumer gro”相关问题

  • 第1题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第2题：

    You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）

    • A、 The command will be executed successfully.
    • B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
    • C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
    • D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
    • E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

    正确答案:E

  • 第3题：

    You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f29371： pending area is not active  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA/x7f06512： at line 1  What action would you take to overcome this error？（）

    • A、create the Pending Area before creating the consumer group
    • B、activate the Pending Area before creating the consumer group
    • C、increase the size of the large pool to accommodate the Pending Area
    • D、increase the size of the shared pool to accommodate the Pending Area
    • E、increase the size of the database buffer cache to accommodate the Pending Area

    正确答案:A

  • 第4题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第5题：

    The corporate network of Certkiller consists of a Windows Server 2008 single Active Directory domain. The domain has two servers named Certkiller 1 and Certkiller 2.  To ensure central monitoring of events you decided to collect all the events on one server， Certkiller 1. To collect events from Certkiller  2. and transfer them to Certkiller 1， you configured the required event subscriptions.  You selected the Normal option for the Event delivery optimization setting by using the HTTP protocol. However， you discovered that none of the subscriptions work.  Which of the following actions would you perform to configure the event collection and event forwarding on the two servers（）

    • A、Through Run window execute the winrm quickconfig command on Certkiller 2.
    • B、Through Run window execute the wecutil qc command on Certkiller 2.
    • C、Add the Certkiller 1 account to the Administrators group on Certkiller 2.
    • D、Through Run window execute the winrm quickconfig command on Certkiller 1.
    • E、Add the Certkiller 2 account to the Administrators group on Certkiller 1.
    • F、Through Run window execute the wecutil qc command on Certkiller 1.

    正确答案:A,B,C

  • 第6题：

    多选题
    our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）
    A

    All control files are opened.

    B

    All redo log files are opened

    C

    The password file is opened.

    D

    The parameter file is opened.

    E

    All online data files are opened.


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

  • 第7题：

    单选题
    You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f29371： pending area is not active  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA/x7f06512： at line 1  What action would you take to overcome this error？（）
    A

    create the Pending Area before creating the consumer group

    B

    activate the Pending Area before creating the consumer group

    C

    increase the size of the large pool to accommodate the Pending Area

    D

    increase the size of the shared pool to accommodate the Pending Area

    E

    increase the size of the database buffer cache to accommodate the Pending Area


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

  • 第8题：

    单选题
    You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）
    A

    The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.

    B

     The command will not execute successfully because resumable space allocation is enabled at the session level.

    C

     The command will execute successfully and resumable space will be allocated at the session level.

    D

     The command will execute successfully and resumable space will be allocated at the instance level.


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

  • 第9题：

    单选题
    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）
    A

     OPEN

    B

     MOUNT

    C

     NORMAL

    D

     NOMOUNT


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

  • 第10题：

    单选题
    You want to create a consumer group， GROUP1， and you execute the following command in the command/x7fline interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP  （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）;  This command errors out displaying the following message：  ERROR at line 1：  ORA/x7f01031： insufficient privileges  ORA/x7f06512： at "SYS.DBMS_RMIN"， line 115  ORA/x7f06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA/x7f06512： at line 1  What action would you take to overcome this error？（）
    A

    grant SYSDBA to the user

    B

    grant SYSOPER to the user

    C

    grant the RESOURCE role to the user

    D

    use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the user

    E

    grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package


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

  • 第11题：

    多选题
    Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）
    A

    Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

    B

    The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

    C

    The command will, create a common user whose description is contained in the root and each pdb.

    D

    The schema for the common user C # # A_ADMIN can be different in each container.

    E

    The command will create a user in the root container only because the container clause is not used


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

  • 第12题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


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

  • 第13题：

    Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）

    • A、The command drops the file +tdgroupA·231.45678.
    • B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
    • C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
    • D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
    • E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

    正确答案:D

  • 第14题：

    You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

    • A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
    • B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
    • C、 The command will execute successfully and resumable space will be allocated at the session level.
    • D、 The command will execute successfully and resumable space will be allocated at the instance level.

    正确答案:B

  • 第15题：

    our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）

    • A、All control files are opened.
    • B、All redo log files are opened
    • C、The password file is opened.
    • D、The parameter file is opened.
    • E、All online data files are opened.

    正确答案:B,E

  • 第16题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第17题：

    ertkiller .com has purchased laptop computers that will be used to connect to a wireless network. You create a laptop organizational unit and create a Group Policy Object （GPO） and configure user profiles by utilizing the names of approved wireless networks. You link the GPO to the laptop organizational unit. The new laptop users complain to you that they cannot connect to a wireless network.  What should you do to enforce the group policy wireless settings to the laptop computers（）

    • A、Execute gpupdate/target：computer command at the command prompt on laptop computers
    • B、Execute Add a network command and leave the SSID （service set identifier） blank
    • C、Execute gpupdate/boot command at the command prompt on laptops computers
    • D、Connect each laptop computer to a wired network and log off the laptop computer and then login again.
    • E、None of the above

    正确答案:D

  • 第18题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第19题：

    单选题
    You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）
    A

     The command will be executed successfully.

    B

     The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

    C

     The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

    D

     The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.

    E

     The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.


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

  • 第20题：

    单选题
    You execute the following block of code：   SQL>BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   （ SIMPLE_PLAN => ’DEPARTMENTS’，   CONSUMER_GROUP1 => ’PAYROLLL’，   GROUP1_CPU => 50，   CONSUMER_GROUP2 => ’SALES’，   GROUP2_CPU => 25，   CONSUMER_GROUP3 => ’MARKETING’，   GROUP3_CPU => 25）；   END；   SQL>/   What is a prerequisite for using the simple resource plan created by executing the above code？（）
    A

     You must assign users to consumer groups.

    B

     You must grant the switch privilege to the users.

    C

     You must create a resource plan directive.

    D

     You must specify the complex resource plan.


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

  • 第21题：

    单选题
    You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）
    A

     grant SYSDBA to the user

    B

     grant SYSOPER to the user

    C

     grant the RESOURCE role to the user

    D

     use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use

    E

     grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package


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

  • 第22题：

    单选题
    You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’，  COMMENT => ’New Group’）；  This command errors out displaying the following message：  ERROR at line 1：  ORA-29371： pending area is not active  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108  ORA-06512： at line 1  What action would you take to overcome this error？（）
    A

     activate the Pending Area before creating the consumer group

    B

     create the Pending Area before creating the consumer group

    C

     increase the size of the database buffer cache to accommodate the Pending Area

    D

     increase the size of the shared pool to accommodate the Pending Area

    E

     increase the size of the large pool to accommodate the Pending Area


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

  • 第23题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

相关内容