1z0-147 Oracle - Braindumps.com.ua: question list for "Oracle9i: Program with PL/SQL", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-147: Oracle9i: Program with PL/SQL

#1. What can you do with the DBMS_LOB package?

Show comments for this question (1)
Add comments
Link to this question

#2. Examine this procedure:

 CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN 
 NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID LAST_NAME) 
 VALUES (V ID, V_LAST_NAME);  
 COMMIT;  
 END;

This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?

Show comments for this question (0)
Add comments
Link to this question

#3. Which three describe a stored procedure? (Choose three.)

Show comments for this question (0)
Add comments
Link to this question

#4. Examine this package:

 CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT 
 prodid FROM product ORDER BY prodid DESC;  
 PROCEDURE prod;  
 PROCEDURE proc2;  
 END 
 pack_cur; /CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodid NUMBER; 
 PROCEDURE prod IS BEGIN OPEN c1;  
 LOOP FETCH c1 INTO v_prodid; 
 DBMS_OUTPUT.PUT_LINE(’Row is: c1%ROWCOUNT); 
 EXIT WHEN c1%ROWCOUNT &gt= 3; 
 END LOOF END prod; 
  PROCEDURE proc2 IS BEGIN LOOP FETCH c1 INTO v_prodid; 
 DBMS_OUTPUT.PUT_LINEQR0w is: IIc1%ROWCOUNT);  
 EXIT WHEN c1%ROWCOUNT &gt= 6;  
 END LOOP;  
 CLOSE c1;  
 END proc2; 
 END pack_cur; /

The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure PROC1 from SQL*Plus with the command: The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure PROC 1 from SQL*Plus with the command: EXECUTE pack_cur.proc1. You execute the procedure PROC1 from SQL*PIus with the command:
EXECUTE pack_cur.proc1.
You execute the procedure PROC1 from SQL*Plus with the command:
EXECUTE pack_cur.proc1
What is the output in your session?
EXECUTE pack_cur.proc l.
What is the output in your session?
What is the output in your session? A.ERROR at line 1:
What is the output in your session? A. ERROR at line 1: A. ERROR at line 1: B.
Row is:

Show comments for this question (0)
Add comments
Link to this question

#5. Examine this procedure:

 CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in 
 NUMBER, V_CITY in VARCHAR2 DEFAULT ‘AUSTIN’, V_NAME in VARCHAR2) IS BEGIN 
 INSERT INTO TEAM (id, city, name) VALUES (v_id, v_city, v_name);  
 COMMIT;  
 END;

Which two statements will successfully invoke this procedure in SQL*PIus? (Choose two.)

Show comments for this question (0)
Add comments
Link to this question

#6. You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)

Show comments for this question (0)
Add comments
Link to this question

#7. This statement fails when executed:

 CREATE OR REPLACE TRIGGER CALC_TEAM_AVG 
 AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER BAT STAT (PLAYER ID, SEASON 
 YEAR,AT BATS,HIT5) VALUES (:NEW.ID, 1997, 0,0); 
  END;