Databases - Upwork

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
Question: Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?
A
Standard package functions accept LOBs as parameters

B
Standard package function do not accept LOBs as parameters

C
Implicit data conversion is supported for converting LOB to RAW

D
Implicit data conversion is not supported for converting varchar to LOB

Note: Not available
1. Report
Question: Which command is used to disable all triggers on the EMPLOYEES table?
A
Multiple triggers on a table in one command cannot be disabled

B
ALTER TRIGGERS ON TABLE employees DISABLE;

C
ALTER employees DISABLE ALL TRIGGERS;

D
ALTER TABLE employees DISABLE ALL TRIGGERS;

Note: Not available
1. Report

First Prev 57 58 59 60 61 Next Last

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?

Question: Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?

Question: Which command is used to disable all triggers on the EMPLOYEES table?