Online Access Free 1Z0-149 Practice Test

Which three are valid PL/SQL variable names? (Choose three.)

• A.printer_name#
• B.v_fname
• C.#printer_name
• D.leap$year
• E.yesterday's_date
• F.Number_of_days_between_March_and_April
• G.1to7number

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

• A.It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
• B.It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
• C.It will fail at lines 6 and 7.
• D.It will fail only at line 7.

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

• A.AFTER AUDIT
• B.STARTUP
• C.DDL
• D.BEFORE ANALYZE
• E.SHUTDOWN
• F.BEFORE GRANT
• G.SERVERERROR

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

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

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

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