nerdexam
EC-Council

312-92 · Question #80

What will the following SQL command accomplish? USE Accounting GO EXECUTE sp_grantdbaccess guest

The correct answer is D. Add guest user to the Accounting database. See the full explanation below for the reasoning.

Question

What will the following SQL command accomplish? USE Accounting GO EXECUTE sp_grantdbaccess guest

Options

  • AAdd guest user to the Accounting security group
  • BChange default database for guest user to Accounting database
  • CAdd guest group to the Accounting database
  • DAdd guest user to the Accounting database

How the community answered

(71 responses)
  • A
    4% (3)
  • B
    11% (8)
  • C
    3% (2)
  • D
    82% (58)

Community Discussion

No community discussion yet for this question.

Full 312-92 Practice