It creates a task and workload， and executes the task.
It creates a task and workload but does not execute the task.
It produces an error because a template has not been created.
It produces an error because the SQL Tuning Set has not been created.
第1题：
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.
第2题：
A.
B.
C.
D.
第3题：
You need to write a code segment that transfers the first 80 bytes from a stream variable named stream1 into a new byte array named byteArray.You also need to ensure that the code segment assigns the number of bytes that are transferred to an integer variable named bytesTransferred.Which code segment should you use?（）
A.bytesTransferred=stream1.Read（byteArray，0，80）；
B.
C.
D.
第4题：
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）
第5题：
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
第6题：
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
第7题：
Evaluatethefollowingcode：SQL>VARIABLEtask_nameVARCHAR2（255）；SQL>VARIABLEsql_stmtVARCHAR2（4000）；SQL>BEGIN：sql_stmt：=’SELECTCOUNT（*）FROMcustomersWHEREcust_state_province=’’CA’’’；：task_name：=’MY_QUICKTUNE_TASK’；DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，：task_name，：sql_stmt）；END；Whatistheoutcomeofthisblockofcode？（）
A.Itcreatesataskandworkload，andexecutesthetask.
B.Itcreatesataskandworkloadbutdoesnotexecutethetask.
C.Itproducesanerrorbecauseatemplatehasnotbeencreated.
D.ItproducesanerrorbecausetheSQLTuningSethasnotbeencreated.
第8题：
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.
第9题：
Which expressions will evaluate to true if preceded by the following code？（） String a = "hello"； String b = new String（a）； String c = a； char[] d = { ’h’， ’e’， ’l’， ’l’， ’o’ }；
第10题：
Given that Thing is a class， how many objects and reference variables are created by the following code？（） Thing item， stuff； item = new Thing（）； Thing entity = new Thing（）；