QUESTION 26How can you migrate from a LONG to a LOB data type for a column?S(A)Use the DBMS_MANAGE_L
QUESTION 28To be callable from a SQL expression, a user-defined function must do what?(A)Be stored o
QUESTION 29Which two describe a stored procedure? (Choose two)(A)A stored procedure is typically wri
QUESTION 30Examine this code:CREATE OR REPLACE PROCEDURE add_dept( p_name departments.department_nam
QUESTION 31Which three are valid ways to minimize dependency failure? (Choose three)not s~(A)Queryin
QUESTION 33Examine this package:CREATE OR REPLACE PACKAGE manage_empsIStax_rate CONSTANT NUMBER(5,2)
QUESTION 34What can you do with the DBMS_LOB package?long(A)Use the DBMS_LOB.WRITE procedure to writ
QUESTION 35Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEAM_SALARY NUMBER(12,2);PR
QUESTION 36Examine this code:CREATE OR REPLACE PACKAGE comm_packageISg_comm NUMBER := 10;PROCEDURE r
QUESTION 37Examine this code:CREATE OR REPLACE FUNCTION gen_email_name(p_first_name VARCHAR2, p_last
QUESTION 38Examine this procedure:CREATE OR REPLACE PROCEDURE UPD_BAT_STAT(V_ID IN NUMBER DEFAULT 10
QUESTION 39Examine this code:CREATE OR REPLACE PROCEDURE audit_action(p_who VARCHAR2)ASBEGININSERT I
QUESTION 40Which view displays indirect dependencies, indenting each dependency?(A)DEPTREE(B)IDEPTRE
QUESTION 41The OLD and NEW qualifiers can be used in which type of trigger?short(A)Row level DML tri
QUESTION 42Which statement is true?long(A)Stored functions can be called from the SELECT and WHERE c
QUESTION 43Examine the trigger:CREATE OR REPLACE TRIGGER Emp_countAFTER DELETE ON Emp_tabFOR EACH RO
QUESTION 44What is true about stored procedures?shortno 大寫(A)A stored procedure uses the DELCLARE ke
QUESTION 45Examine this code:CREATE OR REPLACE PROCEDURE insert_dept(p_location_id NUMBER)ISv_dept_i
QUESTION 46The creation of which database objects will cause a DDL trigger to fire? (Choose all that
QUESTION 47Which two program declarations are correct for a stored program unit? (Choose two)AC(A)CR
QUESTION 48You need to implement a virtual private database (vpd). In order to have the vpd function