Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Question # 4

Examine these statements from a block of code:

Which two are true? (Choose two.)

A.

The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

B.

Only the PRICE column can be updated in the PRODUCTS table.

C.

The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

D.

The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

E.

An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

Full Access
Question # 5

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

A.

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

B.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

C.

A deterministic function's results always depend on the state of session variables.

D.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

E.

A function is deterministic if it always returns the same result for a specific combination of input values.

F.

The PARALLEL_ENABLE clause can be specified for a nested function.

G.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

Full Access
Question # 6

Which three are valid PL/SQL variable names? (Choose three.)

A.

printer_name#

B.

1to7number

C.

yesterday's_date

D.

leap$year

E.

Number_of_days_between_March_and_April

F.

#printer_name

G.

v_fname

Full Access
Question # 7

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).

Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

A.

B.

C.

D.

E.

Full Access
Question # 8

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

A.

line 5

B.

line 6

C.

line 7

D.

line 4

E.

line 3

F.

line 2

Full Access
Question # 9

In which type of trigger can :OLD and :NEW identifiers be used?

A.

ROW

B.

AFTER SUSPEND

C.

AFTER STATEMENT

D.

BEFORE STATEMENT

Full Access