Download Oracle Database 11g: Program with PL-SQL.1z0-144.CertDumps.2017-12-09.112q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-144 |
| Exam Name: | Oracle Database 11g: Program with PL/SQL |
| Date: | Dec 09, 2017 |
| File Size: | 7 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
View the Exhibit to examine the PL/SQL code:
DECLARE
x NUMBER := 5;
y NUMBER := NULL;
BEGIN
IF x != y THEN — yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE(‘x != y’); — not run
ELSIF x = y THEN — also yields NULL
DBMS_OUTPUT.PUT_LINE(‘x = y’);
ELSE
DBMS_OUTPUT.PUT_LINE
(‘Can’t tell if x and y are equal or not.’);
END IF;
END;
/
SREVROUPUT is on for the session. Which statement is true about the output of the PL/SQL block?
- The output is x = y.
- It produces an error.
- The output is x != y.
- The output is Can't tell if x and y are equal or not.
Correct answer: D
Question 2
Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?
- It issues a warning whenever ERROR: 05003 occur during compilation.
- It causes the compilation to fail whenever the warning ERROR.05003 occurs.
- It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
- It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.
Correct answer: B
Explanation:
References: References:
Question 3
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?
- It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
- It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
- It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
- It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
Correct answer: A
Explanation:
In this case, the debug output will only occur if there is an exception. In this case, the debug output will only occur if there is an exception.
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!