网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）
A
by granting a secure application role to the users
B
by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
C
By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
D
By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
E
By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）A by granting a secure application role to the usersB by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseC By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4D By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.E By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.” 相关考题
考题
You have a file serve that runs windows server 2008. The serve has a shared folder. You need to receive a notification when a user stores more than 500MB of data in the shared folder. You must allow users to store more than 500MB of data in the shared folder.What should you do?（）A.Create a soft quota.B.Create a hard quota.C.Create an active screening file screen.D.Create a passive screening file screen.
考题
You are administering a database and you receive a requirement to apply the following restrictions:1. A connection must be terminated after four unsuccessful login attempts by user.2. A user should not be able to create more than four simultaneous sessions.3. User session must be terminated after 15 minutes of inactivity.4. Users must be prompted to change their passwords every 15 days.How would you accomplish these requirements?（）A. by granting a secure application role to the usersB. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseC. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
考题
In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）A、By assigning profiles for the usersB、By implementing Fine-Grained Auditing （FGA）C、By granting a secure application role to the usersD、By implementing the Database Resource Manager plan
考题
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. There is a database named DB1 in the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user. So which database permission should you give the user?（） A、DELETE B、CONTROL C、DROP DATABASE D、ALTER ANY DATASPACE
考题
A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）A、Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.B、Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.C、Ensure that the login name is created with square brackets （[]）.D、Give the login access to a specific database by using the CREATE USER Transact-SQL statement.
考题
Your database initialization parameter file has the following entry： SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting？（）A、 It drops the connection after the specified number of login attempts fail for any user.B、 It is enforced only if the password profile is enabled for the user.C、 It locks the user account after the specified number of attempts.D、 It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
考题
Which statement is true regarding this setting?（）A、It drops the connection after the specified number of login attempts fail for any user.B、It is enforced only if the password profile is enabled for the user. C、It locks the user account after the specified number of attempts. D、It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
考题
You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）A、by granting a secure application role to the usersB、by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseC、By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4D、By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.E、By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
考题
In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME 2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME 3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER 4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME How would you accomplish the above（）A、by assigning profiles for the usersB、by implementing Fine-Grained Auditing （FGA）C、by granting a secure application role to the usersD、by implementing the Database Resource Manager plan
考题
You are the administrator of a Windows 2000 Professional portable computer that is shared by users in the sales department. You want to configure a roaming user profile for each user. You want each individual user profile setting to be available from any location, including by using a dial-up connection. You log on to the computer by using the local Administrator account. You create user accounts for the users in the sales department. When you attempt to configure each individual user account profile to be a roaming profile, you find that you cannot. You receive the change Profile Type dialog box as shown in the exhibit (Click the Exhibit button) You want to be able to configure each user account to use a roaming user profile. What should you do?（ ）A、From System in Control Panel, select the Change Type option, and then select the Roaming profile option. B、From Users and passwords in Control Panel, select the Advanced tab, and then define the path for the profile location. C、Use the Network Connection wizard to create a virtual private network (VPN) connection to the network, and define the mandatory profile path on each domain user account. D、Connect the portable computer to the network, and configure the user accounts for a roaming user profile.
考题
You have a file serve that runs windows server 2008. The serve has a shared folder. You need to receive a notification when a user stores more than 500MB of data in the shared folder. You must allow users to store more than 500MB of data in the shared folder. What should you do?（）A、Create a soft quota.B、Create a hard quota.C、Create an active screening file screen.D、Create a passive screening file screen.
考题
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string. "Data Source=DB01；UID=’mhamm’；PWD=’password’；" When the application calls the Open method of the SqlConnection object， it displays the following： "Cannot open user default database. Login failed. Login failed for user ’mhamm’". You need to make sure that you can connect to Trades when the user account for the connection is mhamm. What should you do？ （）A、 Change the connection string as follows：Data Source=DB01；Initial Catalog=Trades；UID=mhamm； PWD=password；"B、 Create a login for Mia Hamm on DB01.C、 Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.D、 Change the connection string as follows："Server=DB01；Database=Trades；UID=mhamm；PWD=password；"
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully. So on InstanceB, which Transact-SQL statements should you execute?（） A、USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; B、USE AdventureWorks;ALTER LOGIN Mary ENABLE; C、USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = "Tk@87#34" UNLOCK; D、USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;
考题
You have a file server that runs Windows Server 2008. The server has a shared folder. You need to receive a notifcation when a user stores more than 500MB of data int he shared folder. You must allow users to store more than 500MB of data in the shared folder. What should you do（）？ A、Create a soft quotaB、Create a hard quotaC、create an active screening file screenD、create a passive screening file screen
考题
单选题In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）A
By assigning profiles for the usersB
By implementing Fine-Grained Auditing （FGA）C
By granting a secure application role to the usersD
By implementing the Database Resource Manager plan
考题
单选题You create a method that runs by using the credentials of the end user. You need to use Microsoft Windows groups to authorize the user. You must add a code segment that identifies whether a user is in the local group named Clerk.Which code segment should you use？（）A
AB
BC
CD
D
考题
单选题In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME 2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME 3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER 4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME How would you accomplish the above（）A
by assigning profiles for the usersB
by implementing Fine-Grained Auditing （FGA）C
by granting a secure application role to the usersD
by implementing the Database Resource Manager plan
考题
单选题Which statement is true regarding this setting?（）A
It drops the connection after the specified number of login attempts fail for any user.B
It is enforced only if the password profile is enabled for the user. C
It locks the user account after the specified number of attempts. D
It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
考题
单选题A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）A
Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.B
Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.C
Ensure that the login name is created with square brackets （[]）.D
Give the login access to a specific database by using the CREATE USER Transact-SQL statement.
考题
单选题You are the administrator of a Windows 2000 Professional portable computer that is shared by users in the sales department. You want to configure a roaming user profile for each user. You want each individual user profile setting to be available from any location, including by using a dial-up connection. You log on to the computer by using the local Administrator account. You create user accounts for the users in the sales department. When you attempt to configure each individual user account profile to be a roaming profile, you find that you cannot. You receive the change Profile Type dialog box as shown in the exhibit (Click the Exhibit button) You want to be able to configure each user account to use a roaming user profile. What should you do?（ ）A
From System in Control Panel, select the Change Type option, and then select the Roaming profile option. B
From Users and passwords in Control Panel, select the Advanced tab, and then define the path for the profile location. C
Use the Network Connection wizard to create a virtual private network (VPN) connection to the network, and define the mandatory profile path on each domain user account. D
Connect the portable computer to the network, and configure the user accounts for a roaming user profile.
考题
问答题Topic 5：Should government relief recipients be kept from owning “luxuries”? Questions for Reference: 1. What kind of products will you define as “luxuries”? 2. Should people who receive subsistence allowance from the government be allowed to own luxuries? Why or why not? 3. What do you suggest will be the more “humane” restrictions on those who apply for subsistence allowance?
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully. So on InstanceB, which Transact-SQL statements should you execute?（）A
USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; B
USE AdventureWorks;ALTER LOGIN Mary ENABLE; C
USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = Tk@87#34 UNLOCK; D
USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;
考题
单选题You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）A
by granting a secure application role to the usersB
by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseC
By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4D
By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.E
By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
考题
单选题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. There is a database named DB1 in the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user. So which database permission should you give the user?（）A
DELETE B
CONTROL C
DROP DATABASE D
ALTER ANY DATASPACE
考题
单选题Your database initialization parameter file has the following entry： SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting？（）A
It drops the connection after the specified number of login attempts fail for any user.B
It is enforced only if the password profile is enabled for the user.C
It locks the user account after the specified number of attempts.D
It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
考题
单选题You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string. "Data Source=DB01；UID=’mhamm’；PWD=’password’；" When the application calls the Open method of the SqlConnection object， it displays the following： "Cannot open user default database. Login failed. Login failed for user ’mhamm’". You need to make sure that you can connect to Trades when the user account for the connection is mhamm. What should you do？ （）A
Change the connection string as follows：Data Source=DB01；Initial Catalog=Trades；UID=mhamm； PWD=password；B
Create a login for Mia Hamm on DB01.C
Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.D
Change the connection string as follows：Server=DB01；Database=Trades；UID=mhamm；PWD=password；
考题
单选题In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users： 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above（）A
By assigning profiles for the usersB
By implementing Fine-Grained Auditing （FGA）C
By granting a secure application role to the usersD
By implementing the Database Resource Manager plan
热门标签
最新试卷
