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

A. They can be used in any type of loop.

B. They must have a WHEN condition.

C. They must use labels.

D. They have the same effect on the execution of a loop.

A. #printer_name

B. v_fname

C. printer_name#

D. leap$year

E. yesterday's_date

F. 1to7number

G. Number_of_days_between_March_and_April

A. ALTER

B. CREATE

C. INSERT

D. UPDATE

E. DROP

F. SELECT

G. DELETE

A. When using the RETURNING INTO clause, the data returned can be only single column or expression.

B. The RETURNING clause can be used for remote or parallel deletes.

C. The RETURNING INTO clause and bulk binds may not be used together.

D. The RETURNING INTO clause returns column values for rows affected by DML statements.

E. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

A. OPEN-FOR

B. WHEN

C. FETCH

D. OPEN

E. CLOSE

F. DECLARE

G. INTO

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.