1Z0-908 Question #18: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.

Security

Question

Examine this SQL statement: Which set of privileges will allow Tom to execute this SQL statement?

Options

AGRANT ALL PRIVILEGES ON world'.city' TO tom'@'%'; GRANT SELECT (code') ON
BGRANT UPDATE ON world'.* TO tom'@'%';
CGRANT UPDATE ON world'.city' TO tom'@'%'; GRANT SELECT ON world'.* TO `tom'@'%';
DGRANT UPDATE ON world'.city' TO tom'@'%'; GRANT SELECT ON world'.`country' TO

Unlock 1Z0-908 to see the answer

You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 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.

Unlock 1Z0-908 - $49.99 / 30 days Sign in

Topics

#MySQL GRANT privileges#Authorization hierarchy#Table-level permissions#Privilege combinations

Full 1Z0-908 Practice