Oracle PL/Sql 10g, Databases

Question: Evaluate the following PL/SQL block: DECLARE v_low NUMBER:=2; v_upp NUMBER:=100; v_count NUMBER:=1; BEGIN FOR i IN v_low..v_low LOOP INSERT INTO test(results) VALUES (v_count) v_count:=v_count+1; END LOOP; END; How many times will the executable statements inside the FOR LOOP execute?
A
0

B
1

C
2

D
98

E
100

Note: Not available
1. Report
Question: What can be done with the DBMS_LOB package?
A
Use the DBMS_LOB.WRITE procedure to write data to a BFILE

B
Use the DBMS_LOB.BFILENAME function to locate an external BFILE

C
Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE

D
Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed

Note: Not available
1. Report
Question: Examine the following code: CREATE OR REPLACE TRIGGER UPD_SALARY FOR EACH ROW BEGIN UPDATE TEAM SET SALARY=SALARY+:NEW.SALARY WHERE ID=:NEW.TEAM_ID END; Which statement must be added to make this trigger executable after updating the SALARY column of the PLAYER table?
A
AFTER UPDATE ON PLAYER

B
AFTER SALARY UPDATE OF PLAYER

C
AFTER UPDATE(SALARY) ON PLAYER

D
AFTER UPDATE OF SALARY ON PLAYER

Note: Not available
1. Report
Question: How can migration be done from a LONG to a LOB data type for a column?
A
Use the DBMS_MANAGE_LOB.MIGRATE procedure

B
Use the UTL_MANAGE_LOB.MIGRATE procedure

C
Use the DBMS_LOB.MIGRATE procedure

D
You cannot migrate from a LONG to a LOB data type for a column

E
Using ALTER TABLE statement

Note: Not available
1. Report
Question: Examine the following code: CREATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10; PROCEDURE reset_comm(p_comm IN NUMBER); END comm_package; User MILLER executes the following code at 9:01am: EXECUTE comm_package.g_comm := 15 User Smith executes the following code at 9:05am: EXECUTE comm_package.g_comm := 20 Which of the following 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 Miller

C
g_comm has a value of 20 at 9:06am for both Miller and Smith

D
g_comm has a value of 15 at 9:03 am for both Miller and Smith

Note: Not available
1. Report
Question: The CHECK_SAL procedure calls the UPD_SAL procedure. Both procedures are INVALID.Which command can be issued to recompile both procedures?
A
COMPILE PROCEDURE CHECK_SAL;

B
COMPILE PROCEDURE UPD_SAL;

C
ALTER PROCEDURE CHECK_SAL compile

D
ALTER PROCEDURE UPD_sAL compile

Note: Not available
1. Report
Question: Examine the following procedure: PROCEDURE emp_salary (v_bonus BOOLEAN, V_raise BOOLEAN, V_issue_check in out BOOEAN) is BEGIN v_issue_check:=v_bonus or v_raise; END; If v_bonus=TRUE and v_raise=NULL,which value is assigned to v_issue_check?
A
TRUE

B
FALSE

C
NULL

D
none

Note: Not available
1. Report
Question: Which package construct must be declared and defined within the packages body?
A
Exception

B
Boolean Variable

C
Public Procedure

D
Private Procedure

Note: Not available
1. Report
Question: What happens when rows are found using a FETCH statement?
A
The cursor opens

B
The cursor closes

C
The current row values are loaded into variables

D
Variables are created to hold the current row values

Note: Not available
1. Report
Question: Evaluate the following PL/SQL block: DECLARE result BOOLEAN; BEGIN DELETE FROM EMPloyee WHERE dept_id IN (10,40,50); result:=SQL%ISOPEN; COMMIT: END; What will be the value of RESULT if three rows are deleted?
A
0

B
3

C
TRUE

D
NULL

E
FALSE

Note: Not available
1. Report

First Prev 2 3 4 5 Next Last

Question: Evaluate the following PL/SQL block: DECLARE v_low NUMBER:=2; v_upp NUMBER:=100; v_count NUMBER:=1; BEGIN FOR i IN v_low..v_low LOOP INSERT INTO test(results) VALUES (v_count) v_count:=v_count+1; END LOOP; END; How many times will the executable statements inside the FOR LOOP execute?

Question: What can be done with the DBMS_LOB package?

Question: Examine the following code: CREATE OR REPLACE TRIGGER UPD_SALARY FOR EACH ROW BEGIN UPDATE TEAM SET SALARY=SALARY+:NEW.SALARY WHERE ID=:NEW.TEAM_ID END; Which statement must be added to make this trigger executable after updating the SALARY column of the PLAYER table?

Question: How can migration be done from a LONG to a LOB data type for a column?

Question: The CHECK_SAL procedure calls the UPD_SAL procedure. Both procedures are INVALID.Which command can be issued to recompile both procedures?

Question: Examine the following procedure: PROCEDURE emp_salary (v_bonus BOOLEAN, V_raise BOOLEAN, V_issue_check in out BOOEAN) is BEGIN v_issue_check:=v_bonus or v_raise; END; If v_bonus=TRUE and v_raise=NULL,which value is assigned to v_issue_check?

Question: Which package construct must be declared and defined within the packages body?

Question: What happens when rows are found using a FETCH statement?

Question: Evaluate the following PL/SQL block: DECLARE result BOOLEAN; BEGIN DELETE FROM EMPloyee WHERE dept_id IN (10,40,50); result:=SQL%ISOPEN; COMMIT: END; What will be the value of RESULT if three rows are deleted?