A get b getline c puttextline d put answer d question

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ld you use to append text to the current line of the output buffer? A. GET. B. GET_LINE. C. PUT_TEXT_LINE. D. PUT. Answer: D QUESTION 84: Local procedure A calls remote procedure B. Procedure B was at 8 A. M. procedure A was modified and recompiled at 9 a. m. Report procedure B was latter modified Actualtests.com - The Power of Knowing 1Z0-101 and recompiled at 11a.m. The dependency mode is set to TIMES TEMP. What happens when procedure A is invoked at 1p.m? A. There is no effect on procedure A and it runs successfully. B. Procedure B is invalidated and successfully recompiles when invoked. C. Procedure A is invalidated and successfully recompiles for the first time it is invoked. D. Procedure A is invalidated and successfully recompiles for the second time it is invoked. Answer: D QUESTION 85: CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEAM_SALARY NUMBER(12,2); PROCEDURE ADD_PLAYER(V_ID IN NUMBER,V_LAST_NAME, VARCHER2,V_SALARY NUMBER); END BB_PACK; / CREATE OR REPLACE PACKAGE BODY BB_PACK IS V_PLAYER_AVG NUMBER(4,3); PROCEDURE UPD_PLAYER_STAT (V_ID IN NUMBER,V_AB IN NUMBER DEFAULT4, 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 VARCHER2,V_SALARY NUMBER) IS BEGIN INSERT INTO(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; Which kind of variable is V_PLAYER_AVG? A. Public. Actualtests.com - The Power of Knowing 1Z0-101 B. One time only. C. Private. D. Boolean. Answer: C QUESTION 86: What happens during the parse phase with dynamic SQL? A. Rows are selected and ordered. B. The number of rows processed is returned. C. The validity of the SQL statement is established. D. An area of memory is established to process the SQL statement. E. An area of memory is established to process the SQL statement is released. Answer: C QUESTION 87: Which script file must be executed before you can determine indirect independence's using the DEPTREE AND IDEPTREE VIEWS? A. UTL_IDEPT.SQL. B. UTLIDD.SQL. C. UTLINDD.SQL. D. UTLDTREE.SQL Answer: D QUESTION 88: Which compiler directive must you use to specify the purity of a packaged function when creating a package? A. PRAGMA EXCEPTION_INIT. B. PRAGMA PURITY_CHECK. C. PRAGMA PURITY_RESTRICT. D. PRAGMA RESTRICT_REFERENCES. Answer: D QUESTION 89: The d bug the logic in a stored procedure. How do you monitor the value of variables in the procedure using SQL Plus environment? Actualtests.com - The Power of Knowing 1Z0-101 A. INSERT TEXT_IO.PUT_LINE statement to view data on the screen when the stored procedure is executed. B. Insert break points in the code and observe the variable values displayed to the screen as the procedure is executed. C. Insert DBMS_OUTPUT.PUT_LINE statement to view data on the screen when the stored procedure is executed. D. Insert D BUG VARIABLE statements to view the variable values on the screen as the procedure is executed. Answer: C QUESTION 90: Which two statements are true? (Choose two) A. A function must return a value. B. A procedure must return a value. C. A function executes a PL/SQL statement. D. A function is invoked as part of an expression. E. A procedure must have a return data type specify in its declaration. Answer: A, D QUESTION 91: Which allows a PL/SQL user define a function? A. NEXTVAL. B. HAVING clause of the SELECT COMMAND. C. ALTER TABLE command. D. FROM clause of the SELECT AN UPDATE COMMANDS. Answer: B QUESTION 92: DRAG DROP Drag the purity level simple to match itsdefinition? Actualtests.com - The Power of Knowing 1Z0-101 Answer: Explanation: Note: RNTS refers to Reads No Table State where the acronym RNDS means Reads No Database State which in turn means the tables. They mean the same thing. Actualtests.com - The Power of Knowing...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online