구매 전에 1Z0-144 샘플 문제를 무료로 확인해 보실 수 있습니다. ExamPassdump이 제공하는 Oracle Database 11g: Program with PL/SQL 데모로 문제 품질과 구성을 직접 살펴보신 후 결정하시기 바랍니다.

Oracle 1Z0-144 시험 개요:

Oracle 1Z0-144 시험 요강 주제:

Oracle 1Z0-144 시험에 대한 질문과 답변 모음

최신 Other Oracle Certification 1Z0-144 무료샘플문제

문제 #1

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 the WHEN clause cannot be used with a row-level trigger
D. Because the column list specified with UPDATE in the trigger is not valid
E. Because both the procedure and trigger access the same table

문제 #2

Examine the following code that you plan to execute:

What correction should be performed in the above code?

A. The PROC3 procedure header should be declared at the beginning of the package body.
B. The variable x must be declared in the package body and removed from the specification,
C. The PROC3 procedure should be declared in the package specification.
D. The PROC2 procedure code should be defined in the package body.

문제 #3

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

A. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
B. A function can return multiple values using a single return clause,
C. A procedure can contain a return statement without a value.
D. A function can contain zero or more parameters that are transferred from the calling environment.

문제 #4

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?

A. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
B. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
C. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
D. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

문제 #5

Examine the following PL/SQL code:

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

A. It executes successfully.
B. It generates a run-time exception.
C. It does not execute because of syntax error
D. It executes successfully and generates a warning.

질문과 대답: