1Z0-144最も有効な質問と解答で勉強

Examine the following package specification:

Which statement is true?

• A. g_comm has a value of 15 at 9: 06 AM only for Jones
• B. g_comm has a value of 15 at 9: 03 AM for both Jones and smith
• C. g_comm has a value of 10 at 9: 03 AM for both Jones and smith
• D. g_comm has a value of 20 at 9: 06 AM for both Jones and smith

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 current sysdate 24000
• B. King 17-JUN-87 1500
• C. King 17-JUN-87 24000
• D. King current sysdate 1500

Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

• A. When adding new items to a package, add them to the end of the package.
• B. When adding new items to a package, add them to the beginning of the package.
• C. Reference tables directly avoid using views.
• D. Reference tables indirectly by using views.

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

Execute the following block of code:

What is the outcome?

• A. It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
• B. It gives an error because group functions cannot be used in anonymous blocks
• C. It gives an error because the variable name and column name are the same in the where clause of the select statement.
• D. It executes successfully and correctly gives the result of the sum of salaries in
  department 60.

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