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 advi

第1题：

第2题：

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)

第3题：

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

• A、The tuned plan is not added to the SQL plan baseline.
• B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
• C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
• D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

第4题：

Examine the following PL/SQL block：   DECLARE   my_plans pls_integer； BEGIN  my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END；   Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）

• A、 It is loaded with the FIXED status.
• B、 It is loaded with the ACCEPTED status.
• C、 It is not loaded with the ENABLED status.
• D、 It is not loaded with the ACCEPTED status.

第5题：

What happens when you run the SQL Tuning Advisor with limited scope?（）

• A、Access path analysis is not performed for SQL statements.
• B、SQL structure analysis is not performed for SQL statements.
• C、SQL Profile recommendations are not generated for SQL statements.
• D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

第6题：

You have created a resource plan， DAY. You execute the following code：        SQL> BEGIN        DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE   （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，   GROUP_OR_SUBPLAN => ’DEPARTMENTS’，        CPU_P1=0）；        END；   Then， you issue the following code：        SQL> BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE        （ PLAN => ’DAY’，        COMMENT => ’DEPARTMENTS PLAN’，        GROUP_OR_SUBPLAN => ’DEVELOPERS’，        CPU_P2=100）；        END；   What will be the impact of executing the above code？（）  

• A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
• B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
• C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
• D、 The second code will not execute because one resource plan cannot be used by more than one subplan.

第7题：

You issued the following block of code：        SQL>BEGIN   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 switch privilege is granted to the PROG_ROLE role.
• B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
• C、 The users cannot grant the switch privilege to other users.
• D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）

• A、A list of SQL statements and recommendations for tuning
• B、A list of SQL statements that have been tuned by the Advisor, with before and after metrics
• C、Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
• D、All of the above

第15题：

Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

• A、Access path analysis is not performed for the SQL statements.
• B、SQL structure analysis is not performed for the SQL statements.
• C、SQL Profile recommendations are not generated for the SQL statements.
• D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

第16题：

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.

第17题：

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.

第18题：

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.

第19题：

You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY   BEGIN TRANSACTION   DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY   BEGIN CATCH   DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH；      You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）

• A、Add a COMMIT TRANSACTION command to the CATCH block.
• B、Remove the COMMIT TRANSACTION command from the TRY block.
• C、Add a ROLLBACK TRANSACTION command to the CATCH block.
• D、Add a ROLLBACK TRANSACTION command to the TRY block.

第20题：

第21题：

第22题：

第23题：