Certified of 1z0-147 exam engine materials and braindump for Oracle certification for examinee, Real Success Guaranteed with Updated 1z0-147 pdf dumps vce Materials. 100% PASS oracle9i program with pl/sql exam Today!

2016 Apr 1z0-147 Study Guide Questions:

Q71. Examine this package:

CREATE OR REPLACE PACKAGE BB_PACK

IS

V_MAX_TEAM_SALARY NUMBER ( 12,2) ;

PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY

NUMBER);

END BB_PACK;

/

CREATE OR REPLACE PACKAGE BODY BB_PACK

IS

V_PLAYER_AVG NUMBER84,3);

PROCEDURE UPD_PLAYER_STAT

(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER)

IS

BEGIN

UPDATE PLAYER_BAT_STAT

SET AT_BATS = AT_BATS + V_AB,

HITS = HITS + V_HITS

WHERE PLAYER_ID = V_ID;

COMMIT;

VALIDATE_PLAYER_STAT(V_ID);

END UPD_PLAYER_STAT;

PROCEDURE ADD_PLAYER

(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBERI)

IS

BEGIN

INSERT INTO PLAYER (ID,LAST_NAME, SALARY)

VALUES (V_ID, V_LAST_NAME, V_SALARY);

UPD _PLAYER_STAT (V_ID, 0, 0) ;

END ADD_PLAYER;

END BB_PACK;

If you add an IF statement to the ADD_PLAYER procedure which additional step must you perform?

r A Recompile the ADD PLAYER procedure

Recompile both the BB PACK specification and body

A. Recompile the ADD_PLAYER procedure

B. Recompile both the BB_PACK specification and body

C. Recompile the BB_PACK specification

D. Recompile the BB_PACK body

Answer: D


Q72. Examine this code:

CREATE OR REPLACE PROCEDURE audit_action

(p_who VARCHAR2)

AS

BEGIN

INSERT INTO audit(schema_user) VALUES(p_who);

END audit_action;

/

CREATE OR REPLACE TRIGGER watch_it

AFTER LOGON ON DATABASE

CALL audit_action(ora_login_user)

/

What does this trigger do?

A. The trigger records an audit trail when a user makes changes to the database.

B. The trigger marks the user as logged on to the database before an audit statement is issued.

C. The trigger invoked the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.

D. The trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.

Answer: D


1z0-147 brain dumps

Update 1z0-147 study guide:

Q73. Which statement is true?

A. Stored functions can be called from the SELECT and WHERE clauses only.

B. Stored functions do not permit calculations that involve database links in a distributed environment.

C. Stored functions cannot manipulate new types of data, such as longitude and latitude.

D. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application.

Answer: D


Q74. You want to create procedures, functions and packages Which privilege do you need?

A. EXECUTE CODE object privilege

B. CREATE ANY CODE object privilege

C. CREATE PACKAGE system privilege

D. CREATE PROCEDURE system privilege

E. CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges

Answer: D


1z0-147 practice test

Accurate 1z0-147 resource:

Q75. Examine the trigger heading:

CREATE OR REPLACE TRIGGER salary_check

BEFORE UPDATE OF sal, job ON emp

FOR EACH ROW

Under which condition does this trigger fire?

A. When a row is inserted into the EMP table.

B. When the value of the SAL or JOB column in a row is updated in the EMP table.

C. When any column other than the SAL and JOB columns in a row are updated in the EMP table.

D. Only when both values of the SAL and JOB columns in a row are updated together in the EMP table.

Answer: B


Q76. Which two programming constructs can be grouped within a package? (Choose two)

A. Cursor

B. Constant

C. Trigger

D. Sequence

E. View

Answer: AB


Q77. Which two statements about packages are true? (Choose two)

A. Both the specification and body are required components of a package.

B. The package specification is optional, but the package body is required.

C. The package specification is required, but the package body is optional.

D. The specification and body of the package are stored together in the database.

E. The specification and body of the package are stored separately in the database.

Answer: CE