单选题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？（）Acreate the Pending Area before creating the consumer groupBactivate the Pending Area before creating the consumer groupCincrease the size of the large pool to accommodate the Pending AreaDincrease the size of the shared pool to accommodate the Pending AreaEincrease the size of the database buffer cache to accommodate the Pending Area
单选题
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
参考解析
解析：
暂无解析
相关考题：
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommandlineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA01031：insufficientprivilegesORA06512：atSYS.DBMS_RMIN，line115ORA06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.grantSYSDBAtotheuserB.grantSYSOPERtotheuserC.granttheRESOURCEroletotheuserD.usetheGRANTcommandtogranttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserE.granttheADMINISTER_RESOURCE_MANAGERprivilegetotheuserbyusingthe DBMS_RESOURCE_MANAGER_PRIVSpackage
Youwanttocreateaconsumergroup，GROUP1，andyouexecutethefollowingcommandinthecommand-lineinterface：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP（CONSUMER_GROUP=’group1’，COMMENT=’NewGroup’）；Thiscommanderrorsoutdisplayingthefollowingmessage：ERRORatline1：ORA-29371：pendingareaisnotactiveORA-06512：atSYS.DBMS_RMIN，line115ORA-06512：atSYS.DBMS_RESOURCE_MANAGER，line108ORA-06512：atline1Whatactionwouldyoutaketoovercomethiserror？（）A.activatethePendingAreabeforecreatingtheconsumergroupB.createthePendingAreabeforecreatingtheconsumergroupC.increasethesizeofthedatabasebuffercachetoaccommodatethePendingAreaD.increasethesizeofthesharedpooltoaccommodatethePendingAreaE.increasethesizeofthelargepooltoaccommodatethePendingArea
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
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.
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.
You execute the following block of code： SQLBEGIN 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.
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.
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.
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 userB、 grant SYSOPER to the userC、 grant the RESOURCE role to the userD、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
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 groupB、activate the Pending Area before creating the consumer groupC、increase the size of the large pool to accommodate the Pending AreaD、increase the size of the shared pool to accommodate the Pending AreaE、increase the size of the database buffer cache to accommodate the Pending Area
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
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.
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.
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 computersB、Execute Add a network command and leave the SSID （service set identifier） blankC、Execute gpupdate/boot command at the command prompt on laptops computersD、Connect each laptop computer to a wired network and log off the laptop computer and then login again.E、None of the above
单选题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.
单选题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.
单选题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
单选题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？（）Acreate the Pending Area before creating the consumer groupBactivate the Pending Area before creating the consumer groupCincrease the size of the large pool to accommodate the Pending AreaDincrease the size of the shared pool to accommodate the Pending AreaEincrease the size of the database buffer cache to accommodate the Pending Area
单选题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？（）AThe rebalancing of the disk group would be stopped.BThe rebalancing of the disk group would be completed as fast as possible.CThe command would result in an error because the value of POWER cannot be 0.DThe rebalancing of the disk group would be completed without affecting the disk group DG3.EThe command would result in an error because the disk groups cannot be manually rebalanced.
单选题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.
单选题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 groupB create the Pending Area before creating the consumer groupC increase the size of the database buffer cache to accommodate the Pending AreaD increase the size of the shared pool to accommodate the Pending AreaE increase the size of the large pool to accommodate the Pending Area
单选题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？（）AAssign the Mailbox Search management role to Group1， and then create a retention policy.BAssign the Mailbox Search management role to Group1， and then create a managed folder mailbox policy.CAssign the Mailbox Import Export management role to Group1， and then configure Personal Archivesfor each mailbox.DAssign the Mailbox Import Export management role to Group1， and then instruct Group1 to export mailboxes to personal folder （.pst） files.
单选题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.
单选题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？（）Agrant SYSDBA to the userBgrant SYSOPER to the userCgrant the RESOURCE role to the userDuse the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the userEgrant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
单选题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（）AAdd Group1 to the local Administrators group.BAdd Group1 to the Certificate Publishers group.CAssign the Manage CA permission to Group1.DAssign the Issue and Manage Certificates permission to Group1.
单选题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？（）AThe command drops the file +tdgroupA·231.45678.BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.DThe command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.EThe command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
单选题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 userB grant SYSOPER to the userC grant the RESOURCE role to the userD use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the useE grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
单选题You execute the following block of code： SQLBEGIN 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.