SYS_GROUP gets 100% CPU resources at level 1.
FIN_GROUP1 gets 80% CPU resources at level 1.
FIN_GROUP1 gets 80% CPU resources at level 2.
PAY_GROUP1 gets 20% CPU resources at level 1.
PAY_GROUP1 gets 20% CPU resources at level 2.
OTHER_GROUP gets 100% CPU resources at level 1.
OTHER_GROUP gets 100% CPU resources at level 2.
第1题:
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?()
第2题:
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?()
第3题:
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 creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
第4题:
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?()
第5题:
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?()
第6题:
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?()
第7题:
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?()
第8题:
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-way
B. two-way
C. three-way
D. No handshakes required during authentication
E. None of the above
第9题:
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
第10题:
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?()