多选题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？ （）ASYS_GROUP gets 100% CPU resources at level 1.BFIN_GROUP1 gets 80% CPU resources at level 1.CFIN_GROUP1 gets 80% CPU resources at level 2.DPAY_GROUP1 gets 20% CPU resources at level 1.EPAY_GROUP1 gets 20% CPU resources at level 2.FOTHER_GROUP gets 100% CPU resources at level 1.GOTHER_GROUP gets 100% CPU resources at level 2.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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
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
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
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 filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
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 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 issued the following statement： SQLALTER 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.
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
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 openedC、The password file is opened.D、The parameter file is opened.E、All online data files are opened.
You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT
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
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.
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
多选题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？（）AAll control files are opened.BAll redo log files are openedCThe password file is opened.DThe parameter file is opened.EAll online data files are opened.
多选题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?（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
单选题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 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 issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）AThe 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.
单选题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.
单选题You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A OPENB MOUNTC NORMALD NOMOUNT
单选题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/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 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
多选题Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）ASchema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.BThe C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.CThe command will, create a common user whose description is contained in the root and each pdb.DThe schema for the common user C # # A_ADMIN can be different in each container.EThe command will create a user in the root container only because the container clause is not used
单选题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 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？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened