You issued the following block of code：        SQLBEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL/   Which option is NOT a result of executing the above code？（）  A、 The swit

第1题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader（　）You need to execute a method named DoWork（　） that takes one second to run while the SQL query is executing. DoWork（　） must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

• A、While ar.AsyncWaitHandle Is Nothing DoWork()End Whiledr = cmd.EndExecuteReader(ar)
• B、While Not ar.IsCompleted DoWork()End Whiledr = cmd.EndExecuteReader(ar)
• C、While T hread.CurrentThread.ThreadState = ThreadState.Running DoWork()End Whiledr = cmd.EndExecuteReader(ar)
• D、While Not ar.AsyncWaitHandle.WaitOne() DoWork()End Whiledr = cmd.EndExecuteReader(ar)

第2题：

In your web application，you need to execute a block of code whenever the session object is first created. Which design will accomplish this goal？（）

• A、Create an HttpSessionListener class and implement the sessionInitialized method with that block ofcode.
• B、Create an HttpSessionActivationListener class and implement the sessionCreated method with thatblock of code.
• C、Create a Filter class， call the getSession（false） method， and if the result was null， then execute that block of code.
• D、Create an HttpSessionListener class and implement the sessionCreated method with that block of code.

第3题：

第4题：

Evaluate the following code：   SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers  WHERE cust_state_province =’’CA’’’； ：task_name ：= ’MY_QUICKTUNE_TASK’；  DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，  ：task_name， ：sql_stmt）；  END；   What is the outcome of this block of code？（）  

• A、 It creates a task and workload， and executes the task.
• B、 It creates a task and workload but does not execute the task.
• C、 It produces an error because a template has not been created.
• D、 It produces an error because the SQL Tuning Set has not been created.

第5题：

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

• A、 It performs parallel recompilation of only the stored PL/SQL code.
• B、 It performs sequential recompilation of only the stored PL/SQL code.
• C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
• D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

第6题：

You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）

• A、In the init method.
• B、In the jspInit method.
• C、In the constructor of the JSP’s Java code.
• D、In a JSP declaration， which includes an initializer block.
• E、In a JSP declaration， which includes a static initializer block.

第7题：

You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  

• A、 SQL Access Advisor
• B、 Undo Advisor
• C、 Segment Advisor
• D、 SQL Tuning Advisor

第8题：

第9题：

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.

第10题：

You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

• A、 The code will be executed successfully.
• B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
• C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
• D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.