Which of the following SQL statements will create a new role named PRCLERK?
A) CREATE prclerk;
B) CREATE ROLE prclerk;
C) CREATE ROLE prclerk ON payroll;
D) CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE;

Question

Which of the following SQL statements will create a new role named PRCLERK?​
A) ​CREATE prclerk;
B) ​CREATE ROLE prclerk;
C) ​CREATE ROLE prclerk ON payroll;
D) ​CREATE ROLE prclerk WITH SELECT ANY TABLE PRIVILEGE;

Quizplus · Accepted Answer

The correct syntax to create a new role in SQL is "CREATE ROLE <rolename>". Therefore, option B is the correct choice as it creates a new role named "prclerk". Option A is incorrect as "CREATE" alone does not specify the creation of a new role. Option C is incorrect as "ON payroll" is not a valid syntax to specify the creation of a new role. Option D is incorrect as "WITH SELECT ANY TABLE PRIVILEGE" is used to grant a specific privilege to a role/user, not to create a new role.

Which of the Following SQL Statements Will Create a New