光看書，很難感受正式考試的時間壓力。KaoGuTi 的 1Z0-149 模擬試題重現 Oracle Database 19c: Program with PL/SQL 的真實考試環境，67 道題目讓你在上場前完整演練一遍。

Oracle 1Z0-149 考試概覽:

認證廠商:	Oracle
考試名稱:	Oracle Database 19c：PL/SQL程式設計
考試代碼:	1Z0-149
及格分數:	68%
相關認證:	Oracle Database PL/SQL Developer Certified Professional
考試費用:	USD 245
證照有效期限:	永久有效
考試形式:	選擇題
考試時間:	120 分鐘
實際考試題數:	60
支援語言:	English, Japanese
範例考題:
考試方式:	可選擇線上監考測驗，或透過Oracle授權考試中心進行實體測驗。
必備條件:	無強制先修條件。強烈建議具備SQL基礎與Oracle資料庫基本知識。
官方大綱網址:	https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149

Oracle 1Z0-149 考試大綱主題:

1Z0-149 認證考試問與答

最新的 Oracle Database PL/SQL Developer Certified Professional 1Z0-149 免費考試真題：

問題 #1

Which three are true regarding code based access control (CBAC)? (Choose three.)

A. In a multitenant environment, the DELEGATE option of CBAC cannot be used.
B. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
C. CBAC cannot be used to secure definer's rights.
D. CBAC roles can be granted to a program unit only if they are directly granted to its owner.
E. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
F. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
G. You can use CBAC to attach database roles to a PL/SQL function or procedure only.

問題 #2

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

A. They can be fired when a table is truncated.
B. They must be created in a disabled state.
C. They cannot include the WHEN clause.
D. They can be fired when a privilege is granted to a user.
E. They fire only when a DDL statement is executed by the owner of the trigger.
F. They must be created in an enabled state.
G. They can be fired either before or after a DDL statement executes.

問題 #3

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

A. In line 1, change IN OUT mode to IN mode.
B. In line 1, add the default parameter DEFAULT 2000.
C. In line 2, change IN OUT mode to IN mode.
D. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
E. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F. In line 2, add the default parameter DEFAULT 2000.

問題 #4

Which two are true about collections and RECORD types? (Choose two.)

A. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.
B. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
C. A variable of RECORD type can contain fields of another RECORD type or any collection type.
D. All collections and RECORD types can be stored in table columns.
E. Only associative arrays and nested tables can have elements of RECORD type.
F. Collections and RECORD types are always dense.

問題 #5

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 2
B. line 7
C. line 6
D. line 1
E. line 3
F. line 8

問題與答案：