📝 Question
#1684
SCOTT is a user in the database. Evaluate the commands issued BY the DBA: 1 - CREATE ROLE mgr; 2 - GRANT CREATE TABLE, SELECT ON oe. orders TO mgr; 3 - GRANT mgr, CREATE TABLE TO SCOTT;
✓
Correct Answer
C. Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement
💡
Explanation
The GRANT statement is used to give privileges to a specific user or role, or to all users, to perform actions on database objects.
⌨️ Press
A
B
C
D
to select