1Z0-149 Exam Training Practice Tests (Oracle Database 19c: Program with PL/SQL)]

Question 1

Which is true about EXIT and CONTINUE statements?

A. They can be used in any type of loop. B. They have the same effect on the execution of a loop. C. They must have a WHEN condition. D. They must use labels.

Correct Answer: A

Question 2

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

A. Error in inner block Error in outer block B. Error in inner block Error in outer block Error in calling block C. Error in inner block D. Error in inner block Error in calling block

Correct Answer: C

Question 3

Examine these statements which execute successfully:

Which anonymous block executes successfully?

A.

B.

C.

D.

Correct Answer: D

Question 4

Which two are true about INDEX-BY tables? (Choose two.)

A. The index can be integer only. B. INDEX-BY table types can be created with the CREATE TYPE statement. C. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks. D. The index can be integer or string. E. INDEX-BY table types can be created in PL/SQL blocks only.

Correct Answer: D,E

Question 5

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

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 returns column values for rows affected by DML statements. D. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used. E. The RETURNING INTO clause and bulk binds may not be used together.

Correct Answer: B,D

Question 6

Which two are true about lexical units? (Choose two.)

A. All user-defined identifiers must start with an alphabet. B. Spaces can be embedded in delimiters. C. A character literal with zero characters has the BOOLEAN value NULL. D. Character literals are case-sensitive. E. Identifiers include labels.

Correct Answer: A,D

Question 7

Which two are true about collections and RECORD types? (Choose two.)

A. A variable of RECORD type can contain fields of another RECORD type or any collection type. B. All collections and RECORD types can be stored in table columns. C. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level. D. Only associative arrays and nested tables can have elements of RECORD type. E. Collections and RECORD types are always dense. F. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Correct Answer: D,F

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