ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

45 / 120

Question 45:

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command: GRANT ALL - ON orders, order_items - TO PUBLIC; What must be done to fix the statement? 

Answer options:

A. PUBLIC should be replaced with specific usernames.
B. ALL should be replaced with a list of specific privileges.
C. WITH GRANT OPTION should be added to the statement.
D. Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.