Oracle
1Z0-047 · Question #264
1Z0-047 Question #264: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #264. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the ORDERS table. The ORDERS table belongs to the user OE. HR is another user in the database. Evaluate the commands issued by users OE and HR in the following order: Statement 1 by user OE: GRANT SELECT, UPDATE(customer_id, order_total) ON orders TOhr; Statement 1 by user HR: SELECT * FROM oe.orders; Statement 2 by user HR: UPDATE oe.orders SET order_totah 10000; Which statement is true regarding the above commands?
Exhibit
Options
- AStatement 1 by user OE would not work because the statement has to be issued by the DBA.
- BStatement 2 by user HR would not work because the grant is only for SELECT in a subquery of update.
- CThere are no errors in the statements issued by OE and HR; all the statements would execute successfully.
- DStatement 1 by user HR would not work because SELECT and UPDATE privileges have been granted only
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.