Tag: sql

Quizzes (6) Questions (65)

Questions Related to sql

Multiple choice sql

Which of the following is NOT a valid description of the public role?

  1. The public role captures all default permissions for users in a database.

  2. The public role cannot be dropped.

  3. The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.

  4. The public role cannot have users, groups, or roles assigned to it.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation