1. a. What are the differences between and application trigger and database trigger? Provide an example of each. Ques 2 You are working for E-Bay the Auction Company as a Database Designer. The new VP of Business Development wants to know every time a new customers signs up on their website. What recommendation would you provide to the developers in your group? How will you implement it? Ques 3 The new VP of Business Development is a very ambitious lady. She wants to store a photograph of every listing on E-bay on their server. What technical advice will you give her given Oracle is the storage server for these images. How do you plan on implementing your solution given there is ample of storage space available? Ques 4 Can you convert a LONG to LOB? If so, provide the syntax for doing so. Ques 4 Provide 4 differences between a Trigger and a Stored Procedure How do you drop a Trigger? Ques 5 a. Can functions contain formal parameters with mode IN, OUT and IN OUT? If yes, provide an example. for it). The conditions for insert, update and delete can either be handled inside the trigger or separate procedure. Ques 6 Write code to add a column in employees table to save an employee picture in a binary file. Ques 7 a. How can persistence of variables and cursors improved with packages? Provide an example. b. Write a (one) SQL statement to make a copy of Employee table for employee whose names start with S. Ques 8 Describe steps for creating custom exceptions.