单选题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 AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor

考题 Which traversal method for a binary tree does the following Pascal code illustrate? Procedure traverse(p：pointer)； Begin IfpNIL Then begin Traverse (p^．left)； Process(p)； Traverse(p^．right) End； End_A．pre_orderB．middle_orderC．noneD．last_order

查看答案

考题 You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL 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.B.C.D.

查看答案

考题 View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?() A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

查看答案

考题 YouacceptedtherecommendedSQLProfilebyexecutingthefollowingcode：DECLAREsqlprofile_namevarchar2（30）；BEGINsqlprofile_name：=DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（task_name=’my_task’，profile_name=’my_profile’）；END；Whichadvisorwillanalyzethisprofile？（）A.SQLAccessAdvisorB.UndoAdvisorC.SegmentAdvisorD.SQLTuningAdvisor

查看答案

考题 Which traversal method for a binary tree does the following Pascal code illustrate? procedure traverse (p:pointer); begin if pnil then begin traverse(p ↑ .left); process(p); traverse(p ↑ .right); end end;A．preorderB．postorderC．reorderD．inorder

查看答案

考题 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)

查看答案

考题 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 AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor

查看答案

考题 You executed the following code： SQL CERATE TABLE COUNTRY （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL， COUNTRY_NAME VARCHAR2（20）， CURRENCY_NAME VARCHAR2（20）， CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID）） ORGANIZATION INDEX； Which types of tables will be created automatically？（）A、 journal tableB、 clustered tableC、 mapping tableD、 partitioned table

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：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.

查看答案

考题 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.

查看答案

考题 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.

查看答案

考题 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 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.

查看答案

考题 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.

查看答案

考题 You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） 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==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；B、while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；C、while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；D、while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

查看答案

考题单选题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 AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor

查看答案

考题单选题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.

查看答案

考题单选题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.

查看答案

考题单选题Where can you add your own PL/SQL code in relation-handling triggers?（）A Before the End default relation program section comment. B After the Begin default relation program section comment. C Before the Begin default relation program section comment. D It is not possible to modify the relation-handling code that Forms automatically creates for relations.

查看答案

考题单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（　）;You need to execute a method named Do Work（　） 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==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；B while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；C while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；D while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

查看答案

考题单选题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.

查看答案

考题单选题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.

查看答案

考题单选题Evaluate the following code： SQLVARIABLE task_name VARCHAR2（255）； SQLVARIABLE sql_stmt VARCHAR2（4000）； SQLBEGIN ：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.

查看答案

考题单选题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.

查看答案

考题单选题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)

查看答案

考题单选题To generate recommendations to improve the performance of a set of SQL queries in an application， you execute the following blocks of code： BEGIN dbms_advisor.create_task（dbms_advisor.sqlaccess_advisor，’TASK1’）； END； / BEGIN dbms_advisor.set_task_parameter（’TASK1’，’ANALYSIS_SCOPE’，’ALL’）； dbms_advisor.set_task_parameter（’TASK1’，’MODE’，’COMPREHENSIVE’）； END； / BEGIN dbms_advisor.execute_task（’TASK1’）； dbms_output.put_line（dbms_advisor.get_task_script（’TASK1’））； END； / The blocks of code execute successfully；however，you do not get the required outcome. What could be the reason？（）A A template needs to be associated with the task.B A workload needs to be associated with the task.C The partial or complete workload scope needs to be associated with the task.D The type of structures （indexes， materialized views， or partitions） to be recommended need to be specified for the task.

查看答案

考题单选题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 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.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：