Online 1Z0-144 Practice TestMore Oracle Products >

Free Oracle 1Z0-144 Exam Dumps Questions

Oracle 1Z0-144: Oracle Database 11g: Program with PL/SQL

- Get instant access to 1Z0-144 practice exam questions

- Get ready to pass the Oracle Database 11g: Program with PL/SQL exam right now using our Oracle 1Z0-144 exam package, which includes Oracle 1Z0-144 practice test plus an Oracle 1Z0-144 Exam Simulator.

- The best online 1Z0-144 exam study material and preparation tool is here.

4.5

(1545 ratings)

Question 1

Identify two features of obfuscation. (Choose two.)

A. The Import and Export utilities accept wrapped file

B. SQL' Plus cannot process the obfuscated source file

C. Only the wrap utility can obfuscate multiple programs at a tim

D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a tim

E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

Correct Answer:AC

Question 2

View the Exhibit and examine the structure of the SALGRADE table.
1Z0-144 dumps exhibit
Examine the following code:

What is the outcome?

A. It is created successfull

B. It gives an error because the return clause condition is invali

C. It gives an error because the usage of the host variables is invali

D. It gives an error because the data type of the return clause is invali

Correct Answer:B

Question 3

Which three statements are true about anonymous blocks and subprograms? (Choose three.)

A. Only subprograms can be parameterize

B. Only subprograms are persistent database object

C. Both anonymous blocks and subprograms can be parameterize

D. Both anonymous blocks and subprograms are persistent database objects

E. Only subprograms can return values that persist after the execution of the subprogra

F. Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their executio

Correct Answer:BEF

Question 4

Examine the following PL/SQL code:
1Z0-144 dumps exhibit
The server output is on for the session. Which statement is true about the execution of the code?

A. It displays null if no employee with employee_id 123 exist

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

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

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

Correct Answer:B

Question 5

Which two statements are true about anonymous blocks and named subprograms?
(Choose two)

A. Subprograms are by default executed with definer's right

B. The declare section is optional for both anonymous blocks and subprogram

C. Both anonymous blocks and subprograms execute by default with invoker's right

D. The declare section is mandatory for anonymous blocks and optional for subprogram

Correct Answer:AB

Question 6

View Exhibit1 and examine the structure of the DO table.
1Z0-144 dumps exhibit
View Exhibit2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

A. The assignment in line 7 is not vali

B. The SQL does not support the Boolean data typ

C. A null value cannot be applied to the bind arguments In the using clause in line 10

D. The names of bind variables must be the same as the using clause bind arguments in line 10

Correct Answer:A

START 1Z0-144 EXAM