Databases - Upwork

Question: Which precomplied word is called, which when encountered, immediately binds the numbered exception handler to a name?
A
Pragma

B
Raise

C
Trap

D
Exception_init

Note: Not available
1. Report
Question: What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
A
The validity of the SQL statement is established

B
An area of memory is established to process the SQL statement

C
The SQL statement is run and the number of rows processed is returned

D
The area of memory established to process the SQL statement is released

Note: Not available
1. Report
Question: Examine the following package specification: CREATE OR REPLACE PACKAGE combine_all IS v_string VARCHAR2(100); PROCEDURE combine (p_num_val NUMBER); PROCEDURE combine (p_date_val DATE); PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER); END combine_all; / Which overloaded COMBINE procedure declaration can be added to this package specification?
A
PROCEDURE combine;

B
PROCEDURE combine (p_no NUMBER);

C
PROCEDURE combine (p_val_1 VARCHAR2, p_val_2 NUMBER);

D
PROCEDURE combine_all(p_num_val VARCHAR2, p_char_val NUMBER);

Note: Not available
1. Report
Question: Which part of a database trigger determines the number of times the trigger body executes?
A
Trigger type

B
Trigger body

C
Trigger event

D
Trigger timing

Note: Not available
1. Report
Question: Which table should be queried to check the status of a function?
A
USER_PROCS

B
USER_OBJECTS

C
USER_PROCEDURES

D
USER_PLSQL_UNITS

Note: Not available
1. Report
Question: Which of the following statements is true regarding stored procedures?
A
A stored procedure uses the DECLARE keyword in the procedure specification to declare formal parameters

B
A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification

C
A stored procedure must have at least one executable statement in the procedure body

D
A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters

Note: Not available
1. Report
Question: Examine the following code: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00') THEN RAISE_APPLICATION_ERROR (-20500, 'You may insert into the EMPLOYEES table only during business hours.'); END IF; END; / What type of trigger is it?
A
DML trigger

B
INSTEAD OF trigger

C
Application trigger

D
This is an invalid trigger

Note: Not available
1. Report
Question: Which code is stored in the database when a procedure or function is created in SQL*PLUS?
A
Only P-CODE

B
Only SOURCE code

C
Both SOURCE CODE and P-CODE

D
Neither SOURCE CODE or P-CODE

Note: Not available
1. Report
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

First Prev 56 57 58 59 60 Next Last

Question: Which precomplied word is called, which when encountered, immediately binds the numbered exception handler to a name?

Question: What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

Question: Which part of a database trigger determines the number of times the trigger body executes?

Question: Which table should be queried to check the status of a function?

Question: Which of the following statements is true regarding stored procedures?

Question: Which code is stored in the database when a procedure or function is created in SQL*PLUS?

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?