多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema, application roles, and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.  What should you do?()

  • A、Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
  • B、Query the sys.server_permissions table on Server1.
  • C、Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
  • D、Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题