Which of the following SQL statements will allow a user to enable the DBA role?
A) ENABLE dba;
B) SET ROLE dba;
C) SET dba;
D) none of the above

Question

Which of the following SQL statements will allow a user to enable the DBA role?​
A) ​ENABLE dba;
B) ​SET ROLE dba;
C) ​SET dba;
D) ​none of the above

Quizplus · Accepted Answer

The SET ROLE statement is used to set or enable a specific role for the current user session. Therefore, SET ROLE dba would enable the DBA role for the user. Option A is invalid syntax, and option C is not a valid statement for enabling a role. Option D is incorrect as there is a valid option.

Which of the Following SQL Statements Will Allow a User