最新的Oracle Database 11g: Program with PL/SQL - 1Z0-144免費考試真題

A. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

B. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

C. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

D. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

A. g_comm has a value of 15 at 9: 03 AM for both Jones and smith

B. g_comm has a value of 20 at 9: 06 AM for both Jones and smith

C. g_comm has a value of 15 at 9: 06 AM only for Jones

D. g_comm has a value of 10 at 9: 03 AM for both Jones and smith

A. MY_PROC2 is recompiled but remains unchanged.

B. MY_PROC1 is recompiled without the debugging code.

C. MY_PROC1 is recompiled but remains unchanged.

D. MY_PROC2 is not recompiled.

A. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.

B. The function goes through the parse, bind, and execute phases.

C. The function goes through the parse, bind, execute, and fetch phases.

D. All the processing phases for the function are performed only at run time.

E. The function goes through only the parse and executes phases.

A. It gives an error but saves the inserted rows; however, no rows are updated.

B. It gives an error and all the data manipulation language (DML) statements are rolled back

C. It executes successfully and all the rows are updated.

D. It gives an error but saves the inserted rows and the update to the first row.

A. It executes and the Output is emprec.deptname: Sales.

B. It executes and the Output is emprec.deptname: .

C. It produces an error because NULL is assigned to the emprec.empid field in the record.

D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

A. It displays only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message.

B. It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of a procedure.

C. It displays only
Output buffer not long enough, and exits the anonymous block.

D. It displays
Output buffer not long enough.
This is my test string.-.