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

A. It acts as a package initialization block that executes once, when the package is first invoked within the user session.

B. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.

C. It generates an error because all the blocks of code in a package body must be named.

D. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.

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

B. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

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

D. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

A. It causes the compilation to fail whenever the warning ERROR.05003 occurs.

B. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.

C. It issues a warning whenever ERROR: 05003 occur during compilation.

D. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.

A. It gives an error because the data type of the return clause is invalid.

B. It is created successfully.

C. It gives an error because the return clause condition is invalid.

D. It gives an error because the usage of the host variables is invalid.

A. ON QRXABASE

B. ON SCHEMA

C. AFTER LOGOFF

D. BEFORE LOGOFF

A. They produce an error because you must close and reopen the cursor before each fetch -statement.

B. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

C. Each fetch retrieves the next consecutive row and assigns values to the target variables.

D. Each fetch retrieves the first row and assigns values to the target variables.

A. It executes successfully.

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

C. 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 declarations.

D. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.

A. The PL/SQL block execution terminates immediately.

B. The CONTINUE statement cannot appear outside a loop.

C. The statements after the continue statement in the iteration are executed before terminating the LOOP.

D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop

E. The loop completes immediately and control passes to the statement after end loop.

A. call in line 6

B. call in line 7

C. call in line 8

D. call in line 9