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: 899559
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 question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply