http://https://www.newpassleader.com/Oracle/1Z0-144-exam-preparation-materials.html (103 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 15
Which two statements correctly differentiate functions and procedures? (Choose two.)
A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL/SQL statement.
B. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.
C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.
D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.
Answer: B,C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 16
Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)
A. When a query returns multiple rows
B. When a column name in a where clause is unknown at compile time
C. When the number of columns selected in a query is not known until run time
D. When a table needs to be created based on an existing table structure at run time
E. When privileges need to be granted to a new user to access an existing schema at run time
Answer: B,C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 17
Which statements are true about PL/SQL procedures? (Choose all that apply.)
A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
Answer: B,D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 18
Examine the following snippet of code from the DECLARE section of PL/SQL DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?
A. The SAME_NAME variable inherits only the data type from the CUST_NAME variable.
B. The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.
C. The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.
D. The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 19
View Exhibit 1 and examine the structure of the EMP table.

View Exhibit 2 and examine the PL/SQL block of code.

What is the outcome?
A. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
B. It executes successfully and displays the names and salaries of all employees who earn the highest salary.
C. It gives an error because the return type is not valid.
D. It gives an error because the record type is not defined within the function.
E. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
Answer: A

NEW QUESTION NO: 20
Examine the following block of code:

Which line in the above code would result in errors upon execution?
A. line 5
B. line 8
C. line 2
D. line 7
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 21
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 17-JUN-87 1500
B. King 17-JUN-87 24000
C. King current sysdate 1500
D. King current sysdate 24000
Answer: C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 22
Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)
A. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
B. All the processing phases for the function are performed only at run time.
C. The function goes through the parse, bind, execute, and fetch phases.
D. The function goes through the parse, bind, and execute phases.
E. The function goes through only the parse and executes phases.
Answer: A,E

NEW QUESTION NO: 23
/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 public:
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 goes into an infinite loop.
B. It executes successfully and displays only the list of faculty names.
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.
Answer: D
Explanation/Reference:
Explanation:
References:

NEW QUESTION NO: 24
Identify two features of obfuscation. (Choose two.)
A. The Import and Export utilities accept wrapped files.
B. SQL' Plus cannot process the obfuscated source files.
C. Only the wrap utility can obfuscate multiple programs at a time.
D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
Answer: A,C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 25
View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?
A. It executes successfully and gives the desired output.
B. It does not execute because the definition of type population is indexed by VARCHAR2.
C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
D. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
Answer: C
Explanation/Reference:
Explanation:
References: