皮皮学，免费搜题
登录
搜题
【多选题】
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced. So what action should you perform to achieve this goal?（）A.
You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert
B.
You should modify all logins by using the ALTER LOGIN ... HASHED statement.
C.
You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.
D.
You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement.
E.
You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】What's the best way to get from the airport to the city center?
A.
train
B.
taxi
C.
bus
【简答题】校核洪水位与防洪限制水位之间的库容称为 。