DS0-001 · Question #151
DS0-001 Question #151: Real Exam Question with Answer & Explanation
The correct answer is A: REVOKE SELECT. REVOKE SELECT is correct because "view privileges" means the ability to read/query data, which corresponds to the SELECT permission - revoking it removes the resigned employee's ability to see customer records. REVOKE DELETE (B) and REVOKE UPDATE (C) are wrong because they target
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
Explanation
REVOKE SELECT is correct because "view privileges" means the ability to read/query data, which corresponds to the SELECT permission - revoking it removes the resigned employee's ability to see customer records.
REVOKE DELETE (B) and REVOKE UPDATE (C) are wrong because they target modification permissions, not viewing; the question specifically asks about removing view access, and the employee may not have even had those permissions.
UPDATE TABLE tblCustomer (D) is a DML command used to modify data rows, not a security/privilege management command at all - it wouldn't affect permissions in any way.
Memory tip: Match the verb to the action - view = SELECT. Think "I select what I see." When a question mentions viewing or reading data, your first thought should be SELECT privileges.
Community Discussion
No community discussion yet for this question.