Scott Is A User In The Databasep Pre Langsql Cssfilehk1style #117
SCOTT is a user in the database.</p> <pre><code class="language-sql"> 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; </code></pre> <p>Which statement is true regarding the execution of the above commands?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 Concurrency Control - Insertion Deletion Predicate Reads - Quiz No.1.
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; Which statement is true regarding the execution of the above commands?
Statement 1 would not execute because the WITH GRANT option is missing
Statement 1 would not execute because the IDENTIFIED BY clause is missing
Statement 3 would not execute because role and system privileges cannot be granted together in a single GRANT statement
Statement 2 would not execute because system privileges and object privileges cannot be granted together in a single GRANT command
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
