AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-144



You are reading online questions and answers for Oracle Exam 1z0-144 (Oracle Database 11g Program with PL/SQL ) 100% free... Please share this site which will help this community to grow...

Question ID 2627

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

Option A

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

Option B

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

Option C

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

Option D

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

Correct Answer C
Description
Update Date and Time 2016-01-11 13:09:42

Question ID 2628

View the exhibit and examine the structure of the products table.
 
Examine the following code
 
 
Which statement is true when the procedure DELETE_DETAILS is invoked?

Option A

A.    It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
 

Option B

B.    It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
 

Option C

C.    It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
 

Option D

D.    It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

Correct Answer A
Description
Update Date and Time 2016-01-11 13:11:56