All About 1z0-147 download Sep 2016

It is more faster and easier to pass the Oracle 1z0-147 exam by using Accurate Oracle oracle9i program with pl/sql questuins and answers. Immediate access to the Most recent 1z0-147 Exam and find the same core area 1z0-147 questions with professionally verified answers, then PASS your exam with a high score now.

2016 Sep 1z0-147 Study Guide Questions:

Q61. 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

Q62. Which three are true statements about dependent objects? (Choose three)

A. Invalid objects cannot be described.

B. An object with status of invalid cannot be a referenced object.

C. The Oracle server automatically records dependencies among objects.

D. All schema objects have a status that is recorded in the data dictionary.

E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.

F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

Answer: ACF

Q63. A dependent procedure or function directly or indirectly references one or more of which four objects? (Choose four)

A. view

B. sequence

C. privilege 

D. procedure

E. anonymous block

F. packaged procedure or function

Answer: ABDF

1z0-147  actual test

Leading 1z0-147 study guide:

Q64. Why do you use an INSTEAD OF trigger?

A. To perform clean up actions when ending a user session.

B. To insert data into a view that normally does not accept inserts.

C. To insert into an audit table when data is updated in a sensitive column.

D. To modify data in which the DML statement has been issued against an inherently nonupdateable view.

Answer: D

Q65. 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

Q66. Which two tables or views track object dependencies? (Choose two)

A. USER_DEPENDENCIES

B. USER_IDEPTREE

C. IDEPTREE

D. USER_DEPTREE

E. USER_DEPENDS

Answer: AC

certleader.com

Breathing 1z0-147 bundle:

Q67. Procedure PROCESS_EMP references the table EMP.

Procedure UPDATE_EMP updates rows if table EMP through procedure PROCESS_EMP.

There is a remote procedure QUERY_EMP that queries the EMP table through the local procedure PROCESS_EMP.

The dependency mode is set to TIMESTAMP in this session.

Which two statements are true? (Choose two)

A. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated.

B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.

C. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.

D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time.

E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.

Answer: BE

Q68. Examine this package specification:

CREATE OR REPLACE PACKAGE concat_all

IS

v_string VARCHAR2(100);

PROCEDURE combine (p_num_val NUMBER);

PROCEDURE combine (p_date_val DATE);

PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER);

END concat_all;

/

Which overloaded COMBINE procedure declaration can be added to this package specification?

A. PROCEDURE combine;

B. PROCEDURE combine (p_no NUMBER);

C. PROCEDURE combine (p_val_1 VARCHAR2, p_val_2 NUMBER;

D. PROCEDURE concat_all (p_num_val VARCHAR2, p_char_val NUMBER);

Answer: A

Q69. 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

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;

END UPD_PLAYER_STAT;

PROCEDURE ADD_PLAYER

(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER)

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;

You make a change to the body of the BB_PACK package. The BB_PACK body is recompiled.

What happens if the stand alone procedure VALIDATE_PLAYER_STAT references this package?

A. VALIDATE_PLAYER_STAT cannot recompile and must be recreated.

B. VALIDATE_PLAYER_STAT is not invalidated.

C. VALDIATE_PLAYER_STAT is invalidated.

D. VALIDATE_PLAYER_STAT and BB_PACK are invalidated.

Answer: B

Q70. Which two dictionary views track dependencies? (Choose two)

A. USER_SOURCE

B. UTL_DEPTREE

C. USER_OBJECTS

D. DEPTREE_TEMPTAB

E. USER_DEPENDENCIES

F. DBA_DEPENDENT_OBJECTS

Answer: DE

About 1z0-147 Information: 1z0-147 Dumps

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.