Read online free dumps for Oracle- 1z0-144

Here you can read online questions and answers for Oracle Exam 1z0-144 (Oracle Database 11g Program with PL/SQL ) 100% free...

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

All Exam Dumps | oracle 1z0-144 dumps

Read online free dumps for oracle- 1z0-144

Here you can read online questions and answers for oracle Exam 1z0-144 (Oracle Database 11g: Program with PL/SQL) 100% free...

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.