IBM
C2090-610 · Question #10
A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?
The correct answer is D. GRANT UPDATE (dept_name) ON TABLE department TO user1. See the full explanation below for the reasoning.
Question
A table called DEPARTMENT has the following columns:
DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?
Options
- AGRANT ALTER ON TABLE department TO user1
- BGRANT ALTER (dept_name) ON TABLE department TO user1
- CGRANT UPDATE ON TABLE department TO user1
- DGRANT UPDATE (dept_name) ON TABLE department TO user1
How the community answered
(28 responses)- A14% (4)
- B7% (2)
- C4% (1)
- D75% (21)
Community Discussion
No community discussion yet for this question.