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

質問 1

Examine these statements which execute successfully:

Which anonymous block executes successfully?

（A）

（B）

（C）

（D）

正解：A 解答を投票する

質問 2

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

（A）AFTER AUDIT

（B）SERVERERROR

（C）DDL

（D）SHUTDOWN

（E）BEFORE ANALYZE

（F）STARTUP

（G）BEFORE GRANT

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

質問 3

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

（A）a record declared in a procedure

（B）a record declared in a package specification

（C）an associative array indexed by VARCHAR2

（D）an associative array indexed by PLS_INTEGER

（E）a record declared in an anonymous block

（F）a predefined PL/SQL-only data type like BOOLEAN

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

質問 4

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

（A）15000

（B）5000

（C）2500

（D）10000

正解：C 解答を投票する

質問 5

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

（A）PL/SQL code can be compiled and executed based on different versions of Oracle.

（B）It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

（C）PL/SQL code can be compiled and executed based on different versions of the operating system.

（D）The PL/SQL compiler can conditionally include selected parts of a program.

（E）Conditional compilation is disabled by default.

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

質問 6

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 解答を投票する

質問 7

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

（A）

（B）

（C）

（D）

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

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

弊社を連絡する

関連リンク

トップ試験