1z0-149 Exam Dumps - Oracle Database PL/SQL Developer Certified Professional Questions and Answers

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

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

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

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

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

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

They cannot include the WHEN clause.

They must be created in an enabled state.

They can be fired when a table is truncated.

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

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

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

They must be created in a disabled state.

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

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

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

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

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

printer_name#

1to7number

yesterday's_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname