单选题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 d

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

相似考题

1.Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：at"SYS.DBMS_RMIN"，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER"，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage

2.You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） A、 CPU_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2

3. You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.

4.Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=>’group1’，COMMENT=>’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：at"SYS.DBMS_RMIN"，line115ORA-06512：at"SYS.DBMS_RESOURCE_MANAGER"，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.activatethePendingAreabeforecreatingtheconsumergroupB.createthePendingAreabeforecreatingtheconsumergroupC.increasethesizeofthedatabasebuffercachetoaccommodatethePendingAreaD.increasethesizeofthesharedpooltoaccommodatethePendingAreaE.increasethesizeofthelargepooltoaccommodatethePendingArea

更多“单选题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 disp”相关问题

  • 第1题：

    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

  • 第2题：

    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

    • A、 This command would result in an error because the disk group is not empty.
    • B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
    • C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
    • D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
    • E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

    正确答案:A

  • 第3题：

    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

    正确答案:E

  • 第4题：

    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

  • 第5题：

    You have an Exchange Server 2010 organization.  Your companys compliance policy states that the following occurs when a user leaves the company：.The user account is disabled .The user account and mailbox are deleted after six months .All e-mail messages in the mailbox are retained for three years  You need to recommend a solution to retain the e-mail messages of users who leave the company.The solution must meet the following requirements： .Ensure that a group named Group1 can manage the process .Minimize disk space required to store the mailbox databases What should you recommend？（）

    • A、Assign the Mailbox Search management role to Group1， and then create a retention policy.
    • B、Assign the Mailbox Search management role to Group1， and then create a managed folder mailbox policy.
    • C、Assign the Mailbox Import Export management role to Group1， and then configure Personal Archives for each mailbox.
    • D、Assign the Mailbox Import Export management role to Group1， and then instruct Group1 to export mailboxes to personal folder （.pst） files.

    正确答案:D

  • 第6题：

    单选题
    Consider the following configuration：  /devices/D1is a member of disk group dgroupA.  /devices/D2is a member of disk group dgroupA.  /devices/D3is a member of disk group dgroupA.  You plan to add a new disk， /devices/D4，to the disk group dgroupA.  You execute the following command：  SQL> ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’；  Which task would be accomplished by the command？（）
    A

     The command adds the new disk， D4， to the disk group.

    B

     The command would result in an error because the is no disk by the name ’/devices/D*’

    C

     The command will be ignored because disks starting with D are already members of the disk group.

    D

     The command would result in an error because no wildcard characters can be used in the disk name.

    E

     The command first detaches all the member disks starting with D， and the reattaches them including the new disk.


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

  • 第7题：

    单选题
    You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（）
    A

     CPU_MTH

    B

     NEW_CPU_MTH

    C

     CPU_P1

    D

     CPU_P2


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

  • 第8题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）
    A

    The rebalancing of the disk group would be stopped.

    B

    The rebalancing of the disk group would be completed as fast as possible.

    C

    The command would result in an error because the value of POWER cannot be 0.

    D

    The rebalancing of the disk group would be completed without affecting the disk group DG3.

    E

    The command would result in an error because the disk groups cannot be manually rebalanced.


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

  • 第9题：

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

  • 第10题：

    单选题
    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）
    A

     This command would result in an error because the disk group is not empty.

    B

     The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

    C

     The command would result in the contents being moved to the parent disk group and dropping of the disk group.

    D

     The command would result in the disk group being marked as INVALID because it cannot be dropped.

    E

     The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.


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

  • 第11题：

    单选题
    You have an enterprise subordinate certification authority （CA）.   You have a group named Group1.   You need to allow members of Group1 to publish new certificate revocation lists. Members of Group1  must not be allowed to revoke certificates.   What should you do（）
    A

    Add Group1 to the local Administrators group.

    B

    Add Group1 to the Certificate Publishers group.

    C

    Assign the Manage CA permission to Group1.

    D

    Assign the Issue and Manage Certificates permission to Group1.


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

  • 第12题：

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


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

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You have an enterprise subordinate certification authority （CA）. You have a group named  Group1.     You need to allow members of Group1 to publish new certificate revocation lists. Members of  Group1 must not be allowed to revoke certificates.     What should you do（）

    • A、Add Group1 to the local Administrators group.
    • B、Add Group1 to the Certificate Publishers group.
    • C、Assign the Manage CA permission to Group1.
    • D、Assign the Issue and Manage Certificates permission to Group1.

    正确答案:C

  • 第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 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.


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

  • 第19题：

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

  • 第20题：

    单选题
    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
    A

     The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.

    B

     The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

    C

     The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.

    D

     This command will fail because you cannot drop a specific disk in an ASM disk group.

    E

     The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.


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

  • 第21题：

    单选题
    You have an Exchange Server 2010 organization.  Your companys compliance policy states that the following occurs when a user leaves the company：.The user account is disabled .The user account and mailbox are deleted after six months  .All e-mail messages in the mailbox are retained for three years  You need to recommend a solution to retain the e-mail messages of users who leave the company.The solution must meet the following requirements： .Ensure that a group named Group1 can manage the process .Minimize disk space required to store the mailbox databases What should you recommend？（）
    A

    Assign the Mailbox Search management role to Group1， and then create a retention policy.

    B

    Assign the Mailbox Search management role to Group1， and then create a managed folder mailbox policy.

    C

    Assign the Mailbox Import Export management role to Group1， and then configure Personal Archivesfor each mailbox.

    D

    Assign the Mailbox Import Export management role to Group1， and then instruct Group1 to export mailboxes to personal folder （.pst） files.


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

  • 第22题：

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


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

  • 第23题：

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


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

  • 第24题：

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


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

相关内容