1Z0-144 Oracle Exam Questions and Free Practice Test

Question 7

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

What is the outcome when the above code is executed?

A. It executes successfull

B. It gives an error because decode cannot be used in a PL/SQL bloc

C. It gives an error because the AVG function cannot be used in a PL/SQL block

D. It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL bloc

E. It gives an error because both the AVG and decode functions cannot be used in a PL/SQL bloc

Correct Answer:A

Question 8

View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.
1Z0-144 dumps exhibit
Examine the following sequence of commands issued by SCOTT:

What is the outcome?

A. SCOTT’S session displays 5, and then 0, greets session displays 0.

B. SCOTT’S session displays 5, and then 0; green's session displays 5.

C. SCOTT’S session displays 5, and then 5 again, green's session displays 0.

D. SCOTT’S session displays 5, and then 5 again; green's session displays 5.

Correct Answer:B

Question 9

View Exhibit 1 and examine the structure of the EMP table.
1Z0-144 dumps exhibit
View Exhlbit2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effec

B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET packag

C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effec

D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET packag

Correct Answer:B

Question 10

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

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

A. call in line 6

B. call in line 7

C. call in line 8

D. call in line 9

Correct Answer:CD

Question 11

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

What would be the outcome when the code is executed?

A. It executes successfull

B. It gives an error because the SAL variable is not visible in the increase functio

C. It gives an error because the increase function cannot be called from the RAISE_SALARY procedur

D. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declaration

Correct Answer:A

Question 12

Which type of exceptions is qualified as no predefined Oracle server errors?

A. the exceptions that are explicitly raised by the program and can be caught by the exception handler

B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly

D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

Correct Answer:C

START 1Z0-144 EXAM