Unformatted text preview: ckage;
User Jones executes the following code at 9:01am:
EXECUTE comm_package.g_comm := 15
User Smith executes the following code at 9:05am:
EXECUTE comm_paclage.g_comm := 20
Which statement is true?
A. g_comm has a value of 15 at 9:06am for Smith.
B. g_comm has a value of 15 at 9:06am for Jones.
C. g_comm has a value of 20 at 9:06am for both Jones and Smith.
D. g_comm has a value of 15 at 9:03 am for both Jones and Smith.
E. g_comm has a value of 10 at 9:06am for both Jones and Smith.
F. g_comm has a value of 10 at 9:03am for both Jones and Smith
QUESTION 47: Actualtests.com - The Power of Knowing 1Z0-147 Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER)
v_email_name := SUBSTR(p_first_name, 1, 1) ||
SUBSTR(p_last_name, 1, 7) ||
SET email = v_email_name
WHERE employee_id = p_id;
Which statement removes the function?
A. DROP FUNCTION gen_email_name;
B. REMOVE gen_email_name;
C. DELETE gen_email_name;
D. TRUNCATE gen_email_name;
E. ALTER FUNCTION gen_email_name REMOVE;
Stored functions can be permanently removed from the database by dropping them. You
use the following statement for dropping a stand-alone stored function:
DROP FUNCTION ;
Answers B, C, D & E are incorrect & will generate errors
QUESTION 48: Examine this procedure:
CREATE OR REPLACE PROCEDURE UPD_BAT_STAT
(V_ID IN NUMBER DEFAULT 10, V_AB IN NUMBER DEFAULT 4)
SET AT_BATS = AT_BATS + V_AB
WHERE PLAYER_ID = V_ID;
Which two statements will successfully invoke this procedure in SQL *Plus? (Choose
Actualtests.com - The Power of Knowing 1Z0-147
A. EXECUTE UPD_BAT_STAT;
B. EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);
C. EXECUTE UPD_BAT_STAT(31, 'FOUR','TWO');
D. UPD_BAT_STAT(V_AB=>10, V_ID=>31);
E. RUN UPD_BAT_STAT;
A. This is the correct syntax for invoking a function from SQL *Plus. Actual para...
View Full Document
- Fall '09
- Stored procedure, Incorrect Answers