Which command will establish a new role?
A) CREATE NEW ROLE rolename;
B) CREATE ROLE rolename;
C) CREATE ROLE rolename FOR username;
D) CREATE ROLE rolename WITH privilege;

Question

​Which command will establish a new role?
A) ​CREATE NEW ROLE rolename;
B) ​CREATE ROLE rolename;
C) ​CREATE ROLE rolename FOR username;
D) ​CREATE ROLE rolename WITH privilege;

Quizplus · Accepted Answer

The correct syntax for creating a new role in SQL is "CREATE ROLE rolename;". Option A is incorrect because "NEW" is not a valid keyword for creating roles. Option C is incorrect because specifying a username is not required when creating a role. Option D is incorrect because "WITH privilege" does not specify what privileges should be granted to the role.

​Which Command Will Establish a New Role

Which Command Will Establish a New Role