最新的Other Oracle Certification認證 1Z1-144考試題庫

問題1

View the Exhibit and examine the code.

Why does the code give an error on execution?

A. because the lexicon variable is not visible in procedure ADD_ENTRY

B. because the lexicon variable is not initialized in procedure wording

C. because the WORD_LIST variable is not visible in procedure wording

D. because the WORD_LIST parameter in out mode cannot be of a record data type

正確答案: C

問題2

Which two statements are true about the exit statement encountered in loop? (Choose two)

A. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

B. The PL/SQL block execution terminates immediately after the exit statement.

C. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.

D. The loop completes immediately and control passes to the statement after end loop

正確答案: A,D

說明：（僅 VCESoft 成員可見）

問題3

Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)

A. An exception handler should commit the transaction.

B. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.

C. Handle named exceptions whenever possible instead of using when others in exception handlers.

D. Add exception handlers whenever errors occur.

正確答案: B,C

問題4

View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

A. The output Is Can't tell if x and y are equal or not.

B. The output is x = y.

C. It produces an error.

D. The output Is x != y.

正確答案: B

問題5

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

A. When a query returns multiple rows

B. When a table needs to be created based on an existing table structure at run time

C. When the number of columns selected in a query is not known until run time

D. When privileges need to be granted to a new user to access an existing schema at run time

E. When a column name in a where clause is unknown at compile time.

正確答案: C,E

問題6

View the Exhibit to examine the PL/SQL code.

The record for the employee with employee__id 100 in the employees table is as follows;

Identify the correct output for the code.

A. King 17-JUN-87 24000

B. King 17-JUN-87 1500

C. King current sysdate 24000

D. King current sysdate 1500

正確答案: B

問題7

View the Exhibit to examine the PL/SQL block.

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

A. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

B. It does not execute because the definition of type population is indexed by VARCHAR2.

C. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

D. It executes successfully and gives the desired output.

正確答案: D

最新的Oracle Database 11g: Program with PL/SQL - 1Z1-144免費考試真題

最新更新

站內鏈接

聯系我們