Oracle
1Z0-047 · Question #136
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement?
The correct answer is D. Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables. See the full explanation below for the reasoning.
Question
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command:
GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement?
Options
- APUBLIC should be replaced with specific usernames.
- BALL should be replaced with a list of specific privileges.
- CWITH GRANT OPTION should be added to the statement.
- DSeparate GRANT statements are required for ORDERS and ORDER_ITEMS tables.
How the community answered
(31 responses)- A3% (1)
- B6% (2)
- C16% (5)
- D74% (23)
Community Discussion
No community discussion yet for this question.