单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
Evaluate the following block of code:What is the outcome of the above code?() 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.
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
Evaluatethefollowingcode：SQLVARIABLEtask_nameVARCHAR2（255）；SQLVARIABLEsql_stmtVARCHAR2（4000）；SQLBEGIN：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.
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?() A. Bind Variable PeekingB. SQL Plan BaselinesC. Adaptive Cursor SharingD. Bind variable used in a SQL statementE. Literals in a SQL statement
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’ }； A、（a == "Hello"）B、（a == b）C、（a == c）D、a.equals（b）E、a.equals（d）
Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）A、Bind Variable PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement
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（）；A、One object is createdB、Two objects are createdC、Three objects are createdD、One reference variable is createdE、Two reference variables are createdF、Three reference variables are created.
In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）A、The source PL/SQL code will be stored in native machine code.B、The source PL/SQL code will be stored in interpreted byte code.C、The compiled PL/SQL code will be stored in native machine code.D、The compiled PL/SQL code will be stored in interpreted byte code.
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
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.
Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150
You define the following regular expression of currency values: regex tx = new regex("^-?/d+(/./d{2})?$") You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are also required to use this code as the expression in a conditional statement and need to know which code segment to use. What should you do?（）A、The tx.Matches（Bill）B、The tx.Equals（Bill）C、The tx.Match（Bill）D、The tx.IsMatch（Bill）
单选题In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）AThe source PL/SQL code will be stored in native machine code.BThe source PL/SQL code will be stored in interpreted byte code.CThe compiled PL/SQL code will be stored in native machine code.DThe compiled PL/SQL code will be stored in interpreted byte code.
单选题You define the following regular expression of currency values: regex tx = new regex("^-?/d+(/./d{2})?$") You are required to write code that will be used to find whether a string in the variable named Bill matches the regular expression or not. You are also required to use this code as the expression in a conditional statement and need to know which code segment to use. What should you do?（）AThe tx.Matches（Bill）BThe tx.Equals（Bill）CThe tx.Match（Bill）DThe tx.IsMatch（Bill）
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A16 B100 C160 D200 E150
多选题Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）ABind Variable PeekingBSQL Plan BaselinesCAdaptive Cursor SharingDBind variable used in a SQL statementELiterals in a SQL statement
单选题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 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.
多选题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（）；AOne object is createdBTwo objects are createdCThree objects are createdDOne reference variable is createdETwo reference variables are createdFThree reference variables are created.
单选题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 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’ }；A（a == Hello）B（a == b）C（a == c）Da.equals（b）Ea.equals（d）
单选题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?（）AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.