최신Oracle Database 11g: Program with PL/SQL - 1Z0-144무료샘플문제

A. Nested table

B. VARRAYS

C. PL/SQL records

D. Associative arrays

A. The data is automatically committed after the block execution ends,

B. It consists of two transactions

C. It gives an error on execution because sequences cannot be used in anonymous blocks.

D. It consists of a single transaction,

A. It can be used only in a parallelized data manipulation language (DML) statement.

B. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel.

C. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization.

D. It can be used in both a parallelized query and a parallelized DML statement.

E. It can be used only in a parallelized query.

A. The PL/SQL wrapper detects and reports only syntax errors.

B. When wrapping a package or object type, only the body should be wrapped, not the specification.

C. To change a wrapped object, the original source code needs to be modified and then wrapped again

D. The PL/SQL wrapper detects and reports both syntax and semantic errors.

E. To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.

F. When wrapping a package or object type, both the body and specification should be wrapped.

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

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

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

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

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

A. The procedure is created successfully and displays the values 20 and 30 when it is called.

B. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.

C. The procedure gives errors because the parameters should be in out mode.

D. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.

A. It can be the first exception handler.

B. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.

C. It can be the only exception handler for the code.

D. It traps all the exceptions that are not already trapped.

A. The dynamic SQL statement retrieves rows into records.

B. You do not know how many columns a select statement will return, or what their data types will.

C. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

D. The SELECT list is not known until run time.