最新的Other Oracle Certification認證 1Z0-144考試題庫

問題1

Which two statements are true about statement-level and row-level triggers? (Choose two.)

A. A statement trigger fires once even if no rows are affected.

B. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

C. A row trigger fires once even if no rows are affected.

D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

正確答案: A,B

問題2

View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the code.

EKPNOS 7845 and 7900 exist in the EMP table.
Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

A. call in line 8

B. call in line 7

C. call in line 9

D. call in line 6

正確答案: A,C

問題3

View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:

Which statement is true about the above block of code?

A. It consists of a single transaction,

B. The data is automatically committed after the block execution ends,

C. It consists of two transactions

D. It gives an error on execution because sequences cannot be used in anonymous blocks.

正確答案: C

問題4

View Exhibit1 and examine the structure of the EMP table.

View Exhibit2 and examine the PIVSQL block of code.

What is the outcome?

A. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid

B. It gives an error because the record type is not defined within the function

C. It gives an error because the return type is not valid.

D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.

E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.

正確答案: D

問題5

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 WHEN clause cannot be used with a row-level trigger

B. Because both the procedure and trigger access the same table

C. Because the procedure call in the trigger is not valid

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

E. Because the condition specified in the when clause is not valid

正確答案: E

問題6

View the exhibit to examine the PL/SQL code.

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

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

B. All the "no data found" errors in the code are trapped by the exception handler.

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

D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.

正確答案: B

問題7

What is the correct definition of the persistent state of a packaged variable?

A. It is a public variable in a package specification whose value is always consistent across all current active sessions.

B. It is a private variable defined in a procedure or function within a package body whose
value is consistent within a user session.

C. It is a public variable in a package specification whose value is consistent within a user session.

D. It is a private variable in a package body whose value is consistent across all current active sessions.

正確答案: C

問題8

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

A. It gives an error on compilation because it is not a row-level trigger.

B. It compiles successfully but gives an error on execution because it is not a row-level trigger.

C. It compiles and executes successfully.

D. It gives an error on compilation because the exception section Is used in the trigger.

正確答案: A

最新的Oracle Database 11g: Program with PL/SQL - 1Z0-144免費考試真題

最新更新

站內鏈接

聯系我們