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
V_MAX_TEAM_SALARY NUMBER ( 12,2) ;
PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY
CREATE OR REPLACE PACKAGE BODY BB_PACK
(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER)
SET AT_BATS = AT_BATS + V_AB,
HITS = HITS + V_HITS
WHERE PLAYER_ID = V_ID;
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBERI)
INSERT INTO PLAYER (ID,LAST_NAME, SALARY)
VALUES (V_ID, V_LAST_NAME, V_SALARY);
UPD _PLAYER_STAT (V_ID, 0, 0) ;
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
Q72. Examine this code:
CREATE OR REPLACE PROCEDURE audit_action
INSERT INTO audit(schema_user) VALUES(p_who);
CREATE OR REPLACE TRIGGER watch_it
AFTER LOGON ON DATABASE
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.
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.
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
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.
Q76. Which two programming constructs can be grouped within a package? (Choose two)
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.