Latesttests
2018 Jan Oracle Official New Released 1z0-144
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-144.html

Oracle Database 11g: Program with PL/SQL

Question No: 61

Examine the following partial declare section from a block of PL/SQL code

Latesttests 2018 PDF and VCE

Which line(s) in the above code are NOT valid? (Choose all that apply.)

  1. line 2

  2. line 3

  3. line 4

  4. line 5

Answer: B,D

Question No: 62

View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables.

EMPLOYEES

Latesttests 2018 PDF and VCE

DEPAERTMENT

Latesttests 2018 PDF and VCE

EMP_BY_DEPT

Latesttests 2018 PDF and VCE

Examine the following code:

Latesttests 2018 PDF and VCE

What is the outcome on execution of the above code?

  1. It executes successfully but the output statements show different values.

  2. It executes successfully and both output statements show the same values.

  3. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.

  4. It gives an error because the INSERT SELECT construct cannot be used with the FORALL

Answer: A

Question No: 63

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.

SCOTT creates the following trigger:

CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA

BEGIN

RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object#39;); END:

SCOTT does not grant the execute privilege on this trigger to any other users.

For which user(s) would this trigger fire by default when they drop an object in the hr schema?

  1. Only HR

  2. SCOTT and HR

  3. Only SCOTT

  4. SCOTT, HR, and SYS

Answer: A

Question No: 64

Which two statements are true about the usage of the cursor for loops? (Choose two.)

  1. The cursor needs to be closed after the iteration is complete.

  2. The implicit open, fetch, exit, and close of the cursor happen.

  3. The record type must be explicitly declared to control the loop.

  4. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.

Answer: B,D

Question No: 65

View the exhibit to examine the PL/SQL code.

Latesttests 2018 PDF and VCE

Which statement is true about the exception handlers in the PL/SQL code?

  1. All the exceptions in the code are trapped by the exception handler.

  2. All the quot;no data foundquot; errors in the code are trapped by the exception handler.

  3. The PL/SQL program does not execute because an exception is not declared in the declare section.

  4. An exception handler in the code traps the quot;no data foundquot; error after executing the handler code and the program flow returns to the next line of code.

Answer: B

Question No: 66

You want to maintain an audit of the date and time when each user of the database logs off.

Examine the following code:

Latesttests 2018 PDF and VCE

Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.)

  1. ON SCHEMA

  2. ON QRXABASE

  3. AFTER LOGOFF

  4. BEFORE LOGOFF

Answer: A,D

Question No: 67

Examine the following code:

Latesttests 2018 PDF and VCE

What is the outcome?

  1. The procedure is created successfully and displays the values 20 and 30 when it is called.

  2. The procedure gives errors because the parameters should be in out mode.

  3. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.

  4. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.

Answer: C

Question No: 68

View the Exhibit and examine the code.

Latesttests 2018 PDF and VCE

Why does the code give an error on execution?

  1. because the WORD_LIST variable is not visible in procedure wording

  2. because the lexicon variable is not visible in procedure ADD_ENTRY

  3. because the lexicon variable is not initialized in procedure wording

  4. because the WORD_LIST parameter in out mode cannot be of a record data type

Answer: A

Question No: 69

Examine the following partial code:

Latesttests 2018 PDF and VCE

Which statement is correct about the unnamed block of code at the end of a package body?

  1. It generates an error because all the blocks of code in a package body must be named.

  2. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.

  3. It acts as a package initialization block that executes once, when the package is first invoked within the user session.

  4. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.

Answer: C

Question No: 70

Examine the following PL/SQL code:

Latesttests 2018 PDF and VCE

Which statement is true about the execution of the PL/SQL code?

  1. It executes successfully.

  2. It generates a run-time exception.

  3. It does not execute because of syntax error

  4. It executes successfully and generates a warning.

Answer: B

Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm

100% Free Download!
Download Free Demo:1z0-144 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-144 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE