1Z0-149 試験問題を無料オンラインアクセス

Which is true about counter variables in a FOR loop?

• A.It must explicitly be declared.
• B.It cannot be NULL.
• C.It is accessible outside the body of the loop.
• D.It can be modified in the body of the loop.

Which two are true about INDEX-BY tables? (Choose two.)

• A.The index can be integer or string.
• B.INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
• C.INDEX-BY table types can be created with the CREATE TYPE statement.
• D.The index can be integer only.
• E.INDEX-BY table types can be created in PL/SQL blocks only.

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.

Examine this DECLARE section:

Which line will cause an error upon execution?

• A.line 3
• B.line 6
• C.line 2
• D.line 5
• E.line 4

Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

• A.It will set all salaries to NULL if it executes successfully.
• B.It might return a run time error depending on who invokes it.
• C.It will always automatically initialize v_raise.
• D.It will always return a run time error because v_raise is not initialized.
• E.It will always return a compile time error because it lacks an EXCEPTION section.
• F.It will set all salaries to 0 if it executes successfully.