New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

  1. Home
  2. Oracle
  3. Oracle Database 11g
  4. 1z0-144 - Oracle Database 11g: Program with PL/SQL
Note! Following 1z0-144 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-144 Exam Dumps - Oracle Database 11g: Program with PL/SQL

Go to page:
Question # 4

Examine the following PL/SQL code:

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

A.

The program abruptly terminates and an exception is raised.

B.

The program executes successfully and the output is No ROWS_FOUND.

C.

The program executes successfully and the query fetches a null value in the V_LNAME variable.

D.

Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised.

Full Access
Question # 5

Which three statements are true about anonymous blocks and subprograms? (Choose three.)

A.

Only subprograms can be parameterized.

B.

Only subprograms are persistent database objects.

C.

Both anonymous blocks and subprograms can be parameterized.

D.

Both anonymous blocks and subprograms are persistent database objects

E.

Only subprograms can return values that persist after the execution of the subprogram.

F.

Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.

Full Access
Question # 6

View Exhibit1 and examine the structure of the product table.

View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.

You then create the following trigger on the product table.

CREATE OR REPLACE TRIGGER check_price__trg

BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price

ON product FOR EACH ROW

WHEN (nev.prod_id <> NVX(old.prod_id,0) OR

New.prod__list_price <> NVL(old.prod_list_price, 0) )

BEGIN

check_price (: new.prod_id) ;

END

/

Examine the following update command for an existing row in the product table.

SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;

Why does it generate an error?

A.

Because the procedure call in the trigger is not valid

B.

Because the condition specified in the when clause is not valid

C.

Because both the procedure and trigger access the same table

D.

Because the WHEN clause cannot be used with a row-level trigger

E.

Because the column list specified with UPDATE in the trigger is not valid

Full Access
Question # 7

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

A.

Reference host or bind variables in a PL7SQL block of code

B.

Tasks that compute and return multiple values to the calling environment

C.

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

D.

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

Full Access
Question # 8

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

Examine the following block of code:

What is the outcome when the above code is executed?

A.

It executes successfully.

B.

It gives an error because decode cannot be used in a PL/SQL block.

C.

It gives an error because the AVG function cannot be used in a PL/SQL block

D.

It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

E.

It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps