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

質問 1

In which of the following scenarios would you recommend using associative arrays?

A. When you want to retrieve an entire row from a table and perform calculations

B. 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

C. When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.

D. When you know the number of elements in advance and the elements are usually accessed sequentially

正解: B,C

質問 2

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS ' /temp/my_files': SQL>GRANT READ ON DIRECTORY my_dir To pubiic:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

SCOTT executes the procedure as follows:
SQL>SET SERVEROUTPUT ON
SQL>EXEC read_file ('MY_DIR', FACULTYLIST.TXT')
What is the outcome?

A. It executes successfully and displays only the list of faculty names.

B. It goes into an infinite loop.

C. It does not execute and displays an error message because the end-of-file condition is not taken care of.

D. It executes successfully and displays the list of faculty names followed by a "no data found" error message.

正解: A

質問 3

Which two statements are true about the usage of the cursor for loops? (Choose two.)

A. The cursor needs to be closed after the iteration is complete.

B. The implicit open, fetch, exit, and close of the cursor happen.

C. The record type must be explicitly declared to control the loop.

D. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.

正解: B,D

質問 4

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What is the outcome when the code is executed?

A. Both blocks compile and execute successfully when called.

B. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

D. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.

正解: A

質問 5

Which statement is true about triggers on data definition language (DDL) statements?

A. They can be defined by all users in the database or only by a specific user.

B. They can be used to track changes to a table, table space, view, or synonym.

C. They can be used to track changes only to a table or index.

D. They are fired only when the owner of the object Issues the DDL statement.

正解: B

質問 6

View the Exhibit and examine the structure of the customer table.

Examine the following trigger code:

What is the outcome when the above trigger is compiled?

A. It gives an error because the statements under updating are not valid.

B. It gives an error because when cannot be used for row-level triggers.

C. It gives an error because the new qualifier in the when clause requires a colon prefix.

D. It compiles successfully.

E. It gives an error because the when condition is not valid.

正解: D

質問 7

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 and HR

C. SCOTT, HR, and SYS

D. Only SCOTT

正解: A

質問 8

Which type of exceptions is qualified as no predefined Oracle server errors?

A. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

B. the exceptions that are explicitly raised by the program and can be caught by the exception handler

C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly

D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

正解: C

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