QUESTION 76Examine this package:CREATE OR REPLACE PACKAGE pack_curISCURSOR c1 ISSELECT prodidFROM pr
QUESTION 77You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to
QUESTION 78When creating stored procedures and functions, which construct allows you to transfer val
QUESTION 80Which code successfully calculates tax?(A)CREATE OR REPLACE PROCEDURE calctax (p_no IN NU
QUESTION 81Examine this code:CREATE OR REPLACE FUNCTION gen_email_name(p_first VARCHAR2, p_last VARC
QUESTION 82Examine the code examples. Which one is correct?(A)CREATE OR REPLACE TRIGGER authorize_ac
QUESTION 83You need to create a DML trigger. Which five pieces need to be identified?1.Table2.DML ev
QUESTION 84Procedure PROCESS_EMP references the table EMP.Procedure UPDATE_EMP updates rows if table
QUESTION 85Examine this package:CREATE OR REPLACE PACKAGE pack_curISCURSOR c1 ISSELECT prodidFROM po
QUESTION 86The add_player procedure inserts rows into the PLAYER table. Which command will show this
QUESTION 89Why do you use an INSTEAD OF trigger?long(A)To perform clean up actions when ending a use
QUESTION 90When using a PL/SQL stored package, how is a side effect defined?long(A)changes only to d
QUESTION 91Examine this packageCREATE OR REPLACE PACKAGE discountsISg_id NUMBER:=7839discount_rate N
QUESTION 92Which two statements about functions are true? (Choose two.)頭尾(A)A function must have a r
QUESTION 93Examine this codeCREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2) ISV_file
QUESTION 94Consider this scenarioA procedure X references a view Y that is based on a table Z .Which
QUESTION 95Examine this codeCREATE OR REPLACE FUNCTION change_dept(p_old_id NUMBER, p_deptname VARCH
QUESTION 97You need to create a trigger to ensure that information in the EMP table is only modified
QUESTION 98Examine this package:CREATE OR REPLACE PACKAGE BB_PACKISV_MAX_TEM_SALARY NUMBER(12,2);PRO