準備考試最怕漫長的等待，Fast2test 深諳這一點。1Z1-144 題庫在付款完成後一分鐘內即送達您的信箱，Oracle Database 11g: Program with PL/SQL 的 103 道練習題立刻就能開始使用。

Oracle 1Z1-144 考試概覽:

Oracle 1Z1-144 考試大綱主題:

1Z1-144 考試熱門問答集

最新的 Other Oracle Certification 1Z1-144 免費考試真題：

問題 #1

You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information.
Which type of composite data type would you choose to fulfill the requirement?

A. PL/SQL records
B. Associative arrays
C. Nested table
D. VARRAYS

問題 #2

Identify two features of obfuscation. (Choose two.)

A. SQL' Plus cannot process the obfuscated source files.
B. Only the wrap utility can obfuscate multiple programs at a time.
C. The Import and Export utilities accept wrapped files.
D. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
E. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

問題 #3

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

A. When a column name in a where clause is unknown at compile time.
B. When a query returns multiple rows
C. When a table needs to be created based on an existing table structure at run time
D. When privileges need to be granted to a new user to access an existing schema at run time
E. When the number of columns selected in a query is not known until run time

問題 #4

Which two statements are true about the instead of triggers? (Choose two.)

A. The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of trigger.
B. Delete operations cannot be performed using the instead of triggers.
C. The instead or triggers must be created to add or modify data through any view.
D. The instead of triggers can be written only for views, and the before and after timing options are not valid.

問題 #5

Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)

A. All the processing phases for the function are performed only at run time.
B. The function goes through the parse, bind, and execute phases.
C. The function goes through only the parse and executes phases.
D. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
E. The function goes through the parse, bind, execute, and fetch phases.

問題與答案：