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

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

• 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.

SERVEROUTPUT is enabled.Which code block will display the values from 1 to 10 in descending order?

Which three are true about PL/SQL subprograms? (Choose three.)

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

• DDL
• AFTER AUDIT
• BEFORE ANALYZE
• SHUTDOWN
• SERVERERROR
• STARTUP
• BEFORE GRANT

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• DISABLE
• ENABLE
• ERROR
• ALL
• SEVERE

Which three statements are true about passing parameters to subprograms? (Choose three.)

• PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.
• IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.
• IN OUT parameters pass initial values to subprograms and return values updated by subprogramsto the caller.
• The actual parameter must be a variable when calling a subprogram with an OUT parameter.
• IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.
• OUT parameters returning values to calling subprograms act like constants in the called subprogram.
• Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

Which three are true about DDL triggers? (Choose three.)

• 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.

Which is true about EXIT and CONTINUE statements?

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

Which statement is true about user-defined records?

• They can be returned from a function.
• Field types must match column types.
• The number of fields must match the number of columns in a table.
• Field names must match selected column names.

In which type of trigger can :OLD and :NEW identifiers be used?

• ROW
• AFTER SUSPEND
• AFTER STATEMENT
• BEFORE STATEMENT