SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELE

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELE

Post by answerhappygod »

SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 - CREATE ROLE mgr;2 - GRANT CREATE TABLE, SELECTON oe. orders -TO mgr;3 - GRANT mgr, create table TO SCOTT;Which statement is true regarding the execution of the above commands?

A. Statement 1 would not execute because the WITH GRANT option is missing.
B. Statement 1 would not execute because the IDENTIFIED BY <password> clause is missing.
C. Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement.
D. Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply