Oracle PL/Sql 10g, Databases

Question: Which cursor dynamically allows passing values to a cursor while opening another cursor?
A
Implicit Cursor

B
User Defined Cursor

C
Parameterized Cursor

D
Explicit Cursor

Note: Not available
1. Report
Question: When the procedure or function is invoked, the Oracle engine loads the compiled procedure or function in the memory area called:
A
PGA

B
SGA

C
Redo Log Buffer

D
Data base buffer cache

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

First Prev 1 2 3 4 5 Next Last

Question: Which cursor dynamically allows passing values to a cursor while opening another cursor?

Question: When the procedure or function is invoked, the Oracle engine loads the compiled procedure or function in the memory area called:

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?