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!
2021 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
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
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