1Z1-144問題集、Oracle実際の試験問題

質問 1

Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)

A. setting the UTL_FILE_DIR initialization parameter

B. using the CREATE DIRECTORY statement to associate an alias with an operating system directory

C. running the UTLMAIL.SQL and prvtmail.plb scripts

D. setting the SMTP_OUT_SERVER initialization parameter

E. granting read and WRITE privileges to control the type of access to files in the operating system

正解: C,D

質問 2

View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?

A. The exception raised in the code is handled by the exception handler for the PAST_DUE exception.

B. It does not execute because you cannot declare an exception with a similar name in the subblock.

C. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

D. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.

正解: C

質問 3

Which two statements are true about database triggers? (Choose two.)

A. Triggers fired by DML statements cannot cascade simultaneously.

B. A trigger can contain a maximum of 32 lines of code.

C. Both DML and DDL statements can cascade any number of triggers,

D. Each trigger can be of a maximum size of 32 K

E. Each trigger can be of any size.

F. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers

正解: C,D

解説: (PassTest メンバーにのみ表示されます)

質問 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 displays an error because the select into clause cannot be used to populate the PL/SQL record type.

B. It displays null if no employee with employee_id 123 exists.

C. It produces the ora-01403: no data found error 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.

正解: C

質問 5

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

A. It gives an error on compilation because it is not a row-level trigger.

B. It compiles and executes successfully.

C. It gives an error on compilation because the exception section Is used in the trigger.

D. It compiles successfully but gives an error on execution because it is not a row-level trigger.

正解: A

質問 6

View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:

Which statement is true about the above trigger?

A. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

B. It gives an error on compilation because it should be a statement-level trigger.

C. It gives an error on compilation because of the commit command in the trigger code

D. It compiles and fires successfully when the credit limit is updated in the customer table.

正解: A

質問 7

View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:

Which statement is true about the above block of code?

A. It consists of a single transaction,

B. The data is automatically committed after the block execution ends,

C. It gives an error on execution because sequences cannot be used in anonymous blocks.

D. It consists of two transactions

正解: D

質問 8

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

A. line 2

B. line 3

C. line 5

D. line 4

正解: B,C

Oracle Database 11g: Program with PL/SQL - 1Z1-144 模擬練習