Gcomm 15 user smith executes the following code at

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: 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 Answer: B 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) RETURN VARCHAR2 IS v_email_name VARCHAR2(19=; BEGIN v_email_name := SUBSTR(p_first_name, 1, 1) || SUBSTR(p_last_name, 1, 7) || '@Oracle.com'; UPDATE employees SET email = v_email_name WHERE employee_id = p_id; RETURN v_email_name; END; 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; Answer: A Explanation: 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) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB WHERE PLAYER_ID = V_ID; COMMIT; END; Which two statements will successfully invoke this procedure in SQL *Plus? (Choose Actualtests.com - The Power of Knowing 1Z0-147 two) 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; Answer: A,B Explanation: A. This is the correct syntax for invoking a function from SQL *Plus. Actual para...
View Full Document

Ask a homework question - tutors are online