Syiha P12 FS F10 as: XVZ Inc. is an Insurance company. Their customer service de
ID: 3729270 • Letter: S
Question
Syiha P12 FS F10 as: XVZ Inc. is an Insurance company. Their customer service desk receives calls from customers regarding claims. Most customers do not remem rep has to frequently search for the Insurance ID number based on CustomerName and DateofBirth. ber their InsuranceID numbers so the customer service Most customer calls are also related to their most recent claims (made 3 days to 3 months ago) Therefore a View (called RecentClaims) has been created to help retrieve only the recent claims from a frequently query the View to e customers. Describe what actions you can take during table of several million claim records. The customer retrieve recent claim information to help th database implementation and physical design to best support the above scenarios customer service rep can quickly find the InsuranceiD and retrieve recent claims service reps very such that the Q6a: Bob is a new customer service employee and needs to be able to update data in the Customer Table. Bob's database username is "Bob. Write the DCL (Data control language) statement to provide Bob with update access to Customer table Q6b: Bob was accidently given permissions to delete records from the Customer table. Write the DCL (Data control language) statement such that Bob cannot delete records from Customer table.Explanation / Answer
Answer)
For a faster search :
1) Use Index
2) Working with the smallest data set required to limit the search
3) Remove unnecessary tables and fields
4) Less use of join clause
a) GRANT : The DCL command that is used to provide access privileges to the user to make changes to the database tables.
Statement: GRANT INSERT, UPDATE, SELECT on Customer_Table | Customer_View TO Bob; ---> This helps to grant all the privileges to the user.
b) REVOKE : The DCL command used to take back the access privilege from the user.
Statement: REVOKE DELETE on Customer_Table | Customer_View from Bob;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.