*CS405 FINAL TERM* *DATE:30\JULY\26* *SHORT Qs* 1.Differentiate between before and after trigger. 2.What is the basic reason of using cursor in SQL SELECT statement. 3.write syntax of pragma exception_INIT and where it is defined in pl\sql block. 4.what is case statement and how they execute? *LONG Qs* 1.Question similar to case statement code example (student grade wali) from handouts 2.Code example of raise_application_error from handouts(page no.89) 3.Suppose an table named as EMPLOYEE with attributes as (EID, ENAME, EDPT, ESLARAY). write a pl\sql block to display all details of those employees whose salary is greater than 50,000 by using cursor based record? *MCQS* 1.Each trigger is contained in how many tables? a)1 b)2 c)3 d)none 2.Exception section in pl\sql block is?optional