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

A. Both anonymous blocks and subprograms execute by default with invoker's rights.

B. The declare section is mandatory for anonymous blocks and optional for subprograms.

C. Subprograms are by default executed with definer's rights.

D. The declare section is optional for both anonymous blocks and subprograms.

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

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 only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message.

A. It gives an error in line 4

B. It gives an error in line 6

C. It gives an error in line 3

D. It executes successfully and displays the output.

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

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

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

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

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

A. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.

B. Use the TO_DATE function in line 7.

C. Use the TO_NUMBER function in line 6.

D. Use the TO_DATE function in line 2.

A. It produces the ora-01403: no data found error if no employee with employee_id 123 exists.

B. It displays an error because the select into clause cannot be used to populate the PL/SQL record type.

C. It displays null if no employee with employee_id 123 exists.

D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.