最新的Oracle Database 19c: Program with PL/SQL - 1Z0-149免費考試真題

A. It will result in an error as the range of the error code can only be from "-20000 to -20999."

B. It will result in an error as the range of the error code can only be from "-2000 to -2999."

C. It will execute successfully and will display the user-defined error message.

D. It will result in an error as the range of the error code can only be from "-1000 to -2000."

A. It must explicitly be declared.

B. It is accessible outside the body of the loop.

C. It can be modified in the body of the loop.

D. It cannot be NULL.

A. Field types must match column types.

B. Field names must match selected column names.

C. They can be returned from a function.

D. The number of fields must match the number of columns in a table.

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

B. They must be created in an enabled state.

C. They cannot include the WHEN clause.

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

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

F. They must be created in a disabled state.

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

A. IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

B. IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

C. IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

D. PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

E. OUT parameters returning values to calling subprograms act like constants in the called subprogram.

F. Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

G. The actual parameter must be a variable when calling a subprogram with an OUT parameter.

A.

B.

C.

D.

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

B. Conditional compilation is disabled by default.

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

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

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