Online Access Free 1Z0-149 Exam Questions

SERVEROUTPUT is enabled.
Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

• A.
• B.
• C.
• D.

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

• A.They cannot include the WHEN clause.
• B.They can be fired either before or after a DDL statement executes.
• C.They can be fired when a privilege is granted to a user.
• D.They must be created in a disabled state.
• E.They can be fired when a table is truncated.
• F.They must be created in an enabled state.
• G.They fire only when a DDL statement is executed by the owner of the trigger.

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

• A.It can be used in the declaration of object types.
• B.It must be specified in the heading of a package body.
• C.It can be used for individual procedures and functions declared in a package specification.
• D.The check is enforced by this clause for direct access and access through dynamic SQL.
• E.It must be specified in the heading of a package specification.

Examine these statements from a block of code:

Which two are true? (Choose two.)

• A.Only the PRICE column can be updated in the PRODUCTS table.
• B.The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
• C.The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• D.An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• E.The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

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

• A.AFTER SUSPEND
• B.AFTER STATEMENT
• C.ROW
• D.BEFORE STATEMENT