Oracle Database 19c: Program with PL/SQL - 1Z0-149 Exam Practice Test

A. a record declared in an anonymous block

B. an associative array indexed by PLS_INTEGER

C. an associative array indexed by VARCHAR2

D. a predefined PL/SQL-only data type like BOOLEAN

E. a record declared in a package specification

F. a record declared in a procedure

A. It will return an error at line 2.

B. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

C. It will return an error at line 3.

D. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

E. It will return an error at line 8.

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

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

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. Only the PRICE column can be updated in the PRODUCTS table.

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

A.

B.

C.

D.

A.

B.

C.

D.

A. In line 1, change IN OUT mode to IN mode.

B. In line 1, add the default parameter DEFAULT 2000.

C. In line 2, add the default parameter DEFAULT 2000.

D. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

F. In line 2, change IN OUT mode to IN mode.

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

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

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

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

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