找考题网-背景图
单项选择题

公司一个新的员工需要访问名为SQL1服务器上的SQLSERVER2005数据库.你用CREATELOGINajonesWITHPASSWORD=’SQLServer$1’为其创建了登录名ajones。新员工报告说:当他在使用ajones登录的时候,收到如下的错误“用户‘ajones’登录失败。该用户与可信的SQLSERVER连接无关联”。你需要解决这个问题并允许这个员工去登录SQL1。你应该怎么做?()
A.改变SQLSERVER安全身份验证模式为“SQLSERVER和Windows身份验证模式”
B.改变SQLSERVER安全身份验证模式为“Windows身份验证模式”
C.保证创建的登录名是带方括号([])的。(例如:[loginname])
D.通过用CREATEUSER语句给新创建的登录访问指定数据库的权限

A.你用CREATELOGINajonesWITHPASSWORD=’SQLServer$1’为其创建了登录名ajones。新员工报告说:当他在使用ajones登录的时候,收到如下的错误“用户‘ajones’登录失败。该用户与可信的SQLSERVER连接无关联”。你需要解决这个问题并允许这个员工去登录SQL1。你应该怎么做?()
A.改变SQLSERVER安全身份验证模式为“SQLSERVER和Windows身份验证模式”
B.改变SQLSERVER安全身份验证模式为“Windows身份验证模式”
C.保证创建的登录名是带方括号([])的。(例如:[loginname])
D.通过用CREATEUSER语句给新创建的登录访问指定数据库的权限
热门试题

单项选择题YouhaveacomputerthatrunsWindowsXPProfessional.NormalbackupsarescheduledtoruneverySundayat22:00EasternTime.DifferentialbackupsarescheduledtoruneveryMondaythroughSaturdayat22:00EasternTime.ThecomputerfailsonThursdayat9:00EasternTime.Youneedtorestorethecomputerfromthebackupbyusingthemostrecentdataavailable.Youmustachievethisgoalbyusingtheminimumamountofadministrativeeffort.YoureinstallWindowsXPProfessionalonthecomputer.Whatshouldyoudonext?()A.RestoreWednesday’sdifferentialbackup.B.RestoreSunday’snormalbackup.RestoreWednesday’sdifferentialbackup.C.RestoreSunday’snormalbackup.RestoreMonday’sdifferentialbackup.RestoreTuesday’sdifferentialbackup.RestoreWednesday’sdifferentialbackup.D.RestoreSunday’snormalbackup.RestoreWednesday’sdifferentialbackup.RestoreTuesday’sdifferentialbackup.RestoreMonday’sdifferentialbackup.

A.NormalbackupsarescheduledtoruneverySundayat22:00EasternTime.DifferentialbackupsarescheduledtoruneveryMondaythroughSaturdayat22:00EasternTime.ThecomputerfailsonThursdayat9:00EasternTime.Youneedtorestorethecomputerfromthebackupbyusingthemostrecentdataavailable.Youmustachievethisgoalbyusingtheminimumamountofadministrativeeffort.YoureinstallWindowsXPProfessionalonthecomputer.Whatshouldyoudonext?()
A.RestoreWednesday’sdifferentialbackup.
B.RestoreSunday’snormalbackup.RestoreWednesday’sdifferentialbackup.
C.RestoreSunday’snormalbackup.RestoreMonday’sdifferentialbackup.RestoreTuesday’sdifferentialbackup.RestoreWednesday’sdifferentialbackup.
D.RestoreSunday’snormalbackup.RestoreWednesday’sdifferentialbackup.RestoreTuesday’sdifferentialbackup.RestoreMonday’sdifferentialbackup.