Question 129Asked in BPSC TRE 2.0 (2023) Computer Class 9-10

The user IDs can be added or removed using which of the following fixed roles?

  1. Adb_sysadmin
  2. Bdb_accessadmin
  3. Cdb_securityadmin
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (B) db_accessadmin

Explanation

In SQL Server the db_accessadmin role can add or remove user IDs (access) for a database.

From BPSC TRE 2.0 (2023) Computer Class 9-10 — Previous Year Paper

This is question 129 of BPSC TRE 2.0 (2023) Computer Class 9-10 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.