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

質問 1

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

（A）The default value is NATIVE.

（B）If set to NATIVE, programs are stored in a PL/SQL bytecode format.

（C）It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

（D）If set to NATIVE, programs are stored in platform dependent machine code.

（E）Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

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

質問 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

In which type of trigger can :OLD and :NEW identifiers be used?

（A）BEFORE STATEMENT

（B）ROW

（C）AFTER STATEMENT

（D）AFTER SUSPEND

正解：B 解答を投票する

質問 4

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

（A）Implicit cursor returns only one record.

（B）%Isopen is always false in Implicit Cursor.

（C）%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

（D）Explicit cursor can return more than one record.

（E）%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

（F）%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

（G）%Isopen is always false in Explicit Cursor.

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

質問 5

Which is true about counter variables in a FOR loop?

（A）It is accessible outside the body of the loop.

（B）It cannot be NULL.

（C）It can be modified in the body of the loop.

（D）It must explicitly be declared.

正解：B 解答を投票する

質問 6

Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

（A）Object privileges to execute a replaced function must be regranted to those users who had the privilege.

（B）A function definition can be modified without dropping and re-creating it.

（C）Object privileges to execute a replaced function are retained by those users who had the privileges.

（D）Function based indexes remain usable when replacing the function on which the index depends.

（E）This clause can be used only for procedures and functions.

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

質問 7

Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

（A）It will run successfully producing a result of 4.

（B）DEP_VU must be manually recompiled to successfully run this code.

（C）It will result in an error because table depts has been altered.

（D）It will run successfully producing a result of 5.

正解：A 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験