1Z0-144 Oracle Exam Questions and Free Practice Test

Question 13

View Exhibit1 and examine the structure of the employees table.
1Z0-144 dumps exhibit
User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA:
SQL_CREATE DICTORY my_dir AS '/temp/my_files* ;
SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code.
1Z0-144 dumps exhibit
You issue the following command: You issue the following command:
SQL_EXEC sal_5tatus ('MY_DIR', ‘EMPREPORT.TXT')
What is the outcome?

A. It executes successfully and creates the repor

B. It gives an error because the text file should be opened in append mod

C. It gives an error because the "no data found" condition is not handled to come out of the loo

D. It gives an error because user SCOTT should be granted both read and write privileges to the directory alia

E. It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a fil

Correct Answer:A

Question 14

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. Only SCOTT

D. SCOTT, HR, and SYS

Correct Answer:A

Question 15

Examine the following partial code:
1Z0-144 dumps exhibit
Which statement is correct about the unnamed block of code at the end of a package body?

A. It generates an error because all the blocks of code in a package body must be name

B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specificatio

C. It acts as a package initialization block that executes once, when the package is first invoked within the user sessio

D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable valu

Correct Answer:C

Question 16

Which two tasks should be created as functions instead of as procedures? (Choose two.)

A. Reference host or bind variables in a PL7SQL block of code

B. Tasks that compute and return multiple values to the calling environment

C. Tasks that compute a value that must be returned to the calling environment

D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

Correct Answer:AC
Explanation/Reference:
Functions are used to return a value. Functions must return only a single value.
Procedure are used to perform an action.
Both functions and procedures are using to do a special task or action. In functions it is
must to return a single value, where as in procedures it’s not compulsory

Question 17

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 complet

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

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

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

Correct Answer:BD

Question 18

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

A. A procedure can contain a return statement without a valu

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 environmen

Correct Answer:A
Reference: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm (using the return statement)

START 1Z0-144 EXAM