[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-144 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-144
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-144.html

Oracle Database 11g: Program with PL/SQL

Question No: 31

Examine the following PL/SQL code:

Ensurepass 2018 PDF and VCE

The server output is on for the session. Which statement is true about the execution of the code?

  1. It displays null if no employee with employee_id 123 exists.

  2. It produces the ora-01403: no data found error if no employee with employee_id 123 exists.

  3. It displays an error because the select into clause cannot be used to populate the PL/SQL record type.

  4. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.

Answer: B

Question No: 32

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

  1. Reference host or bind variables in a PL7SQL block of code

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

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

  4. 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

Answer: A,C

Explanation: Explanation/Reference:

Functions are used to return a value. Functions must return only a single value. Procedure are used to perform an action.

Both functions and procedures are using to do a special task or action. In functions it is must to return a single value, where as in procedures it’s not compulsory

Question No: 33

View the Exhibit and examine the code and its outcome on execution:

Ensurepass 2018 PDF and VCE

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

  1. MY_PROC2 is not recompiled.

  2. MY_PROC1 is recompiled but remains unchanged.

  3. MY_PROC2 is recompiled but remains unchanged.

  4. MY_PROC1 is recompiled without the debugging code.

Answer: A,D

Question No: 34

Which two statements are true about PL/SQL exception propagation? (Choose two.)

  1. The exception reproduces Itself In successive enclosing blocks until a handler is found.

  2. Exception- can propagate across the remote subprograms that are called through database links.

  3. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

  4. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.

Answer: A,C

Question No: 35

View the Exhibit and examine the structure of the departments table in SCOTT’s schema.

Ensurepass 2018 PDF and VCE

Examine the following block of code:

CREATE OR REPLACE PROCEDURE add_dept(

p_id NUMBER, p_name VARCHAR2) IS BEGIN

INSERT INTO departments VALUES lt;p_id, p_name, NULL, NULL); END;

/

The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.

Which two statements are true in the above scenario? (Choose two.)

  1. JONES executes the procedure with definer#39;s rights.

  2. JONES executes the procedure with invoker#39;s rights.

  3. SCOTT should grant only the execute privilege for the procedure to JONES.

  4. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

Answer: A,C

Question No: 36

View the Exhibit and examine the structure of the EMP table.

Ensurepass 2018 PDF and VCE

Which stages are performed when the above block is executed? (Choose all that apply)

  1. Bind

  2. Parse

  3. Fetch

  4. Execute

Answer: B,C,D

Question No: 37

Examine the following snippet of code from the DECLARE section of PL/SQL

DECLARE

Cust_name VERCHAR2 (20) NOT NULL : = ‘Tom Jones’: Same_name cust_name%TYPE:

Which statement is correct about the above snippets of code?

  1. The SAME_NAME variable inherits only the data type from the CUST_NAME variable.

  2. The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.

  3. The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.

  4. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error

Answer: D

Question No: 38

Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)

  1. Add exception handlers whenever errors occur.

  2. An exception handler should commit the transaction.

  3. Handle named exceptions whenever possible instead of using when others in exception handlers.

  4. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.

Answer: C,D

Question No: 39

View the Exhibit to examine the PIVSQL block.

Ensurepass 2018 PDF and VCE

Which statement is true about the output of the PL/SQL block?

  1. It executes and the Output is emprec.deptname: .

  2. It executes and the Output is emprec.deptname: Sales.

  3. It produces an error because NULL is assigned to the emprec.empid field in the record.

  4. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

Answer: A

Question No: 40

View the Exhibit and examine the structure of the customer table.

Ensurepass 2018 PDF and VCE

Examine the following trigger code:

Ensurepass 2018 PDF and VCE

What is the outcome when the above trigger is compiled?

  1. It compiles successfully.

  2. It gives an error because the when condition is not valid.

  3. It gives an error because when cannot be used for row-level triggers.

  4. It gives an error because the statements under updating are not valid.

  5. It gives an error because the new qualifier in the when clause requires a colon prefix.

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-144 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-144 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.