Oracle 1Z0-144 問題集

質問 1：
/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 does not execute and displays an error message because the end-of-file condition is not taken care of.
B. It goes into an infinite loop.
C. It executes successfully and displays only the list of faculty names.
D. It executes successfully and displays the list of faculty names followed by a "no data found" error message.
正解：C

質問 2：
Which statements correctly describe the features of functions and procedures? (Choose all that apply.)
A. A procedure can contain a return statement without a value.
B. A function can return multiple values using a single return clause,
C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
D. A function can contain zero or more parameters that are transferred from the calling environment.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
View the Exhibit and examine the structure of the customer table.
You need to create a trigger to ensure that customers in category "A" and "B" have a credit
limit of more than 8000.
Examine the following trigger.

Which statement is correct about the outcome of this trigger?
A. It gives an error on compilation because the new qualifier can be used only in row-level triggers.
B. It compiles successfully and fires whenever the specified condition is met.
C. It compiles successfully but does not fire even when the condition is met
D. It gives an error on compilation because the new qualifier is prefixed with a colon.
正解：B

質問 4：
Examine the following code:

What is the outcome?
A. The procedure gives errors because the parameters should be in out mode.
B. The procedure is created successfully and displays the values 20 and 30 when it is called.
C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.
正解：C

質問 5：
View the Exhibit to examine the PL/SQL code.

SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
A. The execution fails because of the misplaced else clause.
B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
正解：C

質問 6：
Identify two situations where the DBMS_SQL package should be used. (Choose two.)
A. The SELECT list is not known until run time.
B. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.
C. You do not know how many columns a select statement will return, or what their data types will.
D. The dynamic SQL statement retrieves rows into records.
正解：A,C