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

A. The PL/SQL compiler can conditionally include selected parts of a program.

B. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

C. PL/SQL code can be compiled and executed based on different versions of the operating system.

D. Conditional compilation is disabled by default.

E. PL/SQL code can be compiled and executed based on different versions of Oracle.

A. They can be fired when a privilege is granted to a user.

B. They fire only when a DDL statement is executed by the owner of the trigger.

C. They must be created in an enabled state.

D. They can be fired when a table is truncated.

E. They cannot include the WHEN clause.

F. They must be created in a disabled state.

G. They can be fired either before or after a DDL statement executes.

A. Identifiers include labels.

B. Spaces can be embedded in delimiters.

C. Character literals are case-sensitive.

D. All user-defined identifiers must start with an alphabet.

E. A character literal with zero characters has the BOOLEAN value NULL.

A.

B.

C.

D.

A. This program unit will compile successfully.

B. Initialization of min_bal can be done while using this packaged constant in another program.

C. Initialization of loan_amount can be done while using this packaged variable in another program.

D. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

E. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.

F. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

G. This will not compile successfully because the min_bal constant must be initialized.

A. 15000

B. 2500

C. 10000

D. 5000

A. line 2

B. line 8

C. line 6

D. line 7

E. line 1

F. line 3