Oracle
1Z0-071 · Question #408
1Z0-071 Question #408: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #408. The question stem and answer options stay visible for context.
Question
You need to allow user ANDREW to: 1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table. 2. GRANT that permission to other users. Which statement will do this?
Options
- AGRANT UPDATE (title, address) ON customers TO andrew WITH GRANT OPTION;
- BGRANT UPDATE (title, address) ON customers TO andrew WITH ADMIN OPTION;
- CGRANT UPDATE ON customers.title, customers.address TO andrew WITH ADMIN OPTION;
- DGRANT UPDATE (title, address) ON customers TO andrew;
- EGRANT UPDATE ON customers.title, customers.address TO andrew WITH GRANT OPTION;
- FGRANT UPDATE ON customers.title, customers.address TO andrew;
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.