File Info
| Exam | Oracle Database 11g: Program with PL/SQL |
| Number | 1z0-144 |
| File Name | Oracle.1z0-144.CertKiller.2019-10-29.63q.tqb |
| Size | 4 MB |
| Posted | Oct 29, 2019 |
| Download | Oracle.1z0-144.CertKiller.2019-10-29.63q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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
Question 2
Which two tasks should be created as functions instead of as procedures? (Choose two.)
- Reference host or bind variables in a PL/SQL block of code
- Tasks that compute and return multiple values to the calling environment
- Tasks that compute a value that must be returned to the calling environment
- Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
Correct answer: CD
Question 3
View Exhibit 1 and examine the structure of the EMPLOYEES table.
View Exhibit 2 and examine the code.
What would be the outcome when the code is executed?
- It executes successfully.
- It gives an error because the SAL variable is not visible in the INCREASE function.
- It gives an error because the INCREASE function cannot be called from the RAISE_SALARY procedure.
- 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.
Correct answer: A
