不確定 Fast2test 的 1Z0-144 題庫是否符合您的需求？我們提供 Oracle Database 11g: Program with PL/SQL 免費範例試題，先下載體驗 103 道練習題的編排方式與解析品質，滿意之後再決定購買。

Oracle 1Z0-144 考試概覽:

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

1Z0-144 考試熱門問答集

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

問題 #1

View the Exhibit to examine the PIVSQL block.

Which statement is true about the output of the PL/SQL block?

A. It produces an error because NULL is assigned to the emprec.empid field in the record.
B. It executes and the Output is emprec.deptname: Sales.
C. It executes and the Output is emprec.deptname: .
D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

問題 #2

In which of the following scenarios would you recommend using PL/SQL records?

A. when you know the number of elements in advance and the elements are usually accessed sequentially
B. when you want to retrieve an entire row from a table and perform calculations
C. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked
D. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

問題 #3

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

A. Only HR
B. SCOTT, HR, and SYS
C. Only SCOTT
D. SCOTT and HR

問題 #4

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

A. It produces the ora-01403: no data found error if no employee with employee_id 123 exists.
B. It displays an error because the select into clause cannot be used to populate the PL/SQL record type.
C. It displays null if no employee with employee_id 123 exists.
D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.

問題 #5

Which two statements are correct about PL/SQL package components? (Choose two)

A. A package specification can exist without the package body.
B. A package body can exist without the package specification.
C. A package must have both specification and body.
D. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

問題與答案：