You are an enterprise application developer. You are designing a Web-based application to maintain appointment details.
You consider implementing the following steps to delete an appointment:
Enter a date range or a client ID, or enter a date range and a client ID to get a list of appointments.
Click the Appointment hyperlink. The appointment details are retrieved and displayed.
Click the Delete button.
You need to analyze the requirements and recommend stored procedures. Which three stored procedures should you recommend? (Each correct answer presents part of the solution. Choose three.)
A.
Search for appointments by using client ID.
B.
Search for appointments by using date range.
C.
Search for appointments by using client ID and date range.
D.
Verify if an appointment exists.
E.
Retrieve an appointment.
F.
Retrieve and delete an appointment.
G.
Delete an appointment.