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

質問 1

Which three are true about DDL triggers? (Choose three.)

（A）They fire only when a DDL statement is executed by the owner of the trigger.

（B）They must be created in an enabled state.

（C）They can be fired either before or after a DDL statement executes.

（D）They must be created in a disabled state.

（E）They cannot include the WHEN clause.

（F）They can be fired when a table is truncated.

（G）They can be fired when a privilege is granted to a user.

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

質問 2

Examine this code:
ALTER SESSION SET plsql_warnings='ENABLE:ALL';
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?

（A）There are no compilation warnings or errors.

（B）A severe compilation warning is generated.

（C）A performance compilation warning is generated.

（D）It fails compilation.

（E）An information compilation warning is generated.

正解：C 解答を投票する

質問 3

Examine these statements:

Which is true?

（A）With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

（B）It will result in a compilation error for protected_proc because calling_proc does not exist.

（C）It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

（D）It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

正解：B 解答を投票する

質問 4

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

質問 5

The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

（A）

（B）

（C）

（D）

（E）

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

質問 6

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

（A）It results in an error because USERB doesn't have select privilege on USERA.EMP.

（B）It executes successfully.

（C）It results in an error because Authid Definer is missing from MYPROC.

（D）It results in an error because Authid Current_User is missing from MYPROC.

正解：B 解答を投票する

質問 7

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

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

弊社を連絡する

関連リンク

トップ試験