网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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.
考题
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.
考题
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: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.
考题
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.sqlWhat 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 upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()
A. Parallel compilation of only the stored PL/SQL codeB. Sequential recompilation of only the stored PL/SQL codeC. Parallel recompilation of any stored PL/SQL codeD. Sequential recompilation of any stored PL/SQL codeE. Parallel recompilation of Java codeF. Sequential recompilation of Java code
考题
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.
考题
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
考题
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.
考题
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 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 issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
考题
Examine the following PL/SQL block： SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob； BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END； Which statement describes the effect of the execution of the above PL/SQL block？（） A、 The plan baselines are verified with the SQL profiles.B、 All fixed plan baselines are converted into nonfixed plan baselines.C、 All the nonaccepted SQL profiles are accepted into the plan baseline.D、 The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
考题
单选题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 are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题You issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A
by using the DBMS_REPAIR packageB
by using the DBVERIFY utilityC
by using Block Media RecoveryD
by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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 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？（）AIn the init method.BIn the jspInit method.CIn the constructor of the JSP’s Java code.DIn a JSP declaration， which includes an initializer block.EIn a JSP declaration， which includes a static initializer block.
考题
多选题You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL @utlrp.sqlWhich two actions does the script perform?（）AParallel compilation of only the stored PL/SQL codeBSequential recompilation of only the stored PL/SQL codeCParallel recompilation of any stored PL/SQL codeDSequential recompilation of any stored PL/SQL codeEParallel recompilation of Java codeFSequential recompilation of 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.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.
考题
单选题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 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
考题
单选题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.
考题
单选题Examine the following PL/SQL block： SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob； BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END； Which statement describes the effect of the execution of the above PL/SQL block？（）A
The plan baselines are verified with the SQL profiles.B
All fixed plan baselines are converted into nonfixed plan baselines.C
All the nonaccepted SQL profiles are accepted into the plan baseline.D
The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
热门标签
最新试卷