1z1-149無料問題集「Oracle Database 19c: Program with PL/SQL」

質問 1

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）

正解：C 解答を投票する

質問 2

Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

（A）line 3

（B）line 7

（C）line 8

（D）line 6

（E）line 2

（F）line 1

正解：D、F 解答を投票する

質問 3

Which three are true about user-defined functions? (Choose three.)

（A）Functions can call only other functions.

（B）They must be defined with at least one parameter.

（C）They can be used in CONNECT BY and START WITH clauses.

（D）They can be executed as standalone commands.

（E）They need not return any values.

（F）They can appear in the select list of a SELECT statement.

（G）They can be used in ORDER BY and GROUP BY clauses.

正解：C、F、G 解答を投票する

質問 4

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

（A）The index can be integer only.

（B）INDEX-BY table types can be created with the CREATE TYPE statement.

（C）INDEX-BY table types can be created in PL/SQL blocks only.

（D）The index can be integer or string.

（E）INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

正解：C、D 解答を投票する

質問 5

Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

（A）It executes and displays output.

（B）It returns an error in line 4.

（C）It returns an error in line 9.

（D）It returns an error in line 2.

正解：B 解答を投票する

質問 6

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

（A）line 3

（B）line 7

（C）line 4

（D）line 5

（E）line 6

（F）line 2

正解：D、F 解答を投票する

質問 7

Which two are true about exception handling? (Choose two.)

（A）Predefined exceptions are globally declared in the standard package.

（B）Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

（C）User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

（D）All declared exceptions are raised implicitly by the runtime system.

（E）Internally defined exceptions can be handled only by the OTHERS exception handler.

正解：A、C 解答を投票する

1z1-149 無料問題集「Oracle Database 19c: Program with PL/SQL」

弊社を連絡する

関連リンク

トップ試験