Oracle 1Z0-144 問題集

質問 1：
View the exhibit and examine the structure of the products table.

Examine the following code

Which statement is true when the procedure DELETE_DETAILS is invoked?
A. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
B. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
C. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine the following package specification:

Which statement is true?
A. g_comm has a value of 20 at 9: 06 AM for both Jones and smith
B. g_comm has a value of 15 at 9: 06 AM only for Jones
C. g_comm has a value of 10 at 9: 03 AM for both Jones and smith
D. g_comm has a value of 15 at 9: 03 AM for both Jones and smith
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The loop completes immediately and control passes to the statement after end loop.
C. The statements after the continue statement in the iteration are executed before terminating the LOOP.
D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
E. The CONTINUE statement cannot appear outside a loop.
正解：D,E

質問 4：
Which statements are true about database triggers? (Choose all that apply.)
A. They are implicitly fired when a triggering event occurs, depending on which user is connected
B. They can invoke only PL/SQL procedures
C. They can include SQL and PL/SQL or calls to Java procedures.
D. They are implicitly fired by an event that must occur within an application
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
/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

質問 6：
Which two statements are true about the PL/SQL initialization parameters? (Choose two.)
A. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled
B. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.
C. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.
D. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.
正解：B,C