1z1-149試験無料問題集（67題）「Oracle Database 19c: Program with PL/SQL 認定」

出題：1

Examine these statements:

Which two are true? (Choose two.)

A. Neither table will have a row inserted and committed.

B. The bank_activity_proc will not compile because of the commit.

C. Only one table will have a row inserted and committed.

D. The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

E. Both tables will have a row inserted and committed.

正解：C,D 解答を投票する

出題：2

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,C 解答を投票する

出題：3

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?

正解：A 解答を投票する

出題：4

Examine these statements from a block of code:

Which two are true? (Choose two.)

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

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

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

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

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

正解：B,C 解答を投票する

出題：5

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

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

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

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

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

E. The PARALLEL_ENABLE clause can be specified for a nested function.

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

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.

正解：A,C,G 解答を投票する

出題：6

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

A. It will fail at lines 6 and 7.

B. It will fail only at line 7.

C. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

D. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

正解：B 解答を投票する

出題：7

SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

A.

B.

C.

D.

正解：A 解答を投票する

1z1-149試験無料問題集「Oracle Database 19c: Program with PL/SQL 認定」