Real 1Z0-144 Exam Question Samples For Free

Front 1

Question: 1

Examine the following command:SQL>ALTER SESSIONSET plsql_warnings *'enable: severe','enable: performance', 'ERROR: 05003';What is the implication of theabove command?

A. It issues a warningwhenever ERROR: 05003 occur during compilation.

B. It causes the compilationto fail whenever the warning ERROR.05003 occurs.

C. It issues warnings wheneverthe code causes an unexpected action or wrong results performance problems.

D. It causes the compilationto fail whenever the code gives wrong results or contains statements that arenever executed.

Back 1

Answer: C

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

Front 2

Question: 2

Which two tasks should be created as functions insteadof as procedures? (Choose two.)

A. Reference host or bindvariables in a PL7SQL block of code

B.Tasks that compute and return multiple values to the calling environment

C. Tasks that compute a valuethat must be returned to the calling environment

D.Tasks performed in SQL that increase data independence by processing complexdata analysis within the Oracle server, rather than by retrieving the data intoan application

Back 2

Answer: A, C

Reference host or bind variables in a PL7SQL block of code

Tasks that compute a value that must be returned to the calling environment

Front 3

Question: 5

What would be the outcome whenthe code is executed?

Back 3

A. It executes successfully.

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

C. It gives an error becausethe increase function cannot be called from the RAISE_SALARY procedure.

D.It gives an error because the increase function and the RAISE_SALARY procedureshould be declared at the beginning of the declare section before all the otherdeclarations.