Wednesday, 5 September 2012

A table called EMPLOYEE has the following columns: | System Administration

NAME
DEPARTMENT
PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A. GRANT INDEX phone_number. ON TABLE employee TO user1
B. GRANT ALTER phone_number. ON TABLE employee TO user1
C. GRANT UPDATE phone_number. ON TABLE employee TO user1
D. GRANT REFERENCES phone_number. ON TABLE employee TO user1

Ans : C


No comments: