Online Access Free 1z1-149 Exam Questions

Examine this statement which is submitted for compilation:

Which three are true? (Choose three.)

• A.Initialization of loan_amount can be done while using this packaged variable in another program.
• B.Initialization of min_bal can be done while using this packaged constant in another program.
• C.This program unit will compile successfully.
• D.This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
• E.This will not compile successfully because the min_bal constant must be initialized.
• F.This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
• G.This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.

Which is the correct method to implement a local subprogram in an anonymous block?

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

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

• A.ERROR
• B.SEVERE
• C.ALL
• D.ENABLE
• E.DISABLE

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

Examine this table in the SH schema:

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?

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