CompTIA
DS0-001 · Question #151
An account manager, who had employee ID number 0012, resigned from an organization. The account manager's view privileges need to be removed from the customer table. Which of the following commands wo
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
Data and Database Security
Question
An account manager, who had employee ID number 0012, resigned from an organization. The account manager's view privileges need to be removed from the customer table. Which of the following commands would be the best option for the organization’s database administrator to use to accomplish this task?
Options
- AREVOKE SELECT
- BREVOKE DELETE
- CREVOKE UPDATE
- DUPDATE TABLE tblCustomer
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#REVOKE SELECT#SQL Privileges#Access Control#User Account Management