Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?
A) ALTER USER rthomas SET DEFAULT TO DBA;
B) SET ROLE DBA;
C) ALTER USER rthomas DEFAULT ROLE dba;
D) none of the above

Question

Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?​
A) ​ALTER USER rthomas SET DEFAULT TO DBA;
B) ​SET ROLE DBA;
C) ALTER USER rthomas DEFAULT ROLE dba;​
D) ​none of the above

Quizplus · Accepted Answer

The correct syntax for assigning the default role to a user is ALTER USER [username] DEFAULT ROLE [rolename]. Therefore, the correct statement would be ALTER USER rthomas DEFAULT ROLE dba;

Which of the Following SQL Statements Will Assign the DBA