网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 users
B
by implementing Fine-Grained Auditing （FGA）
C
by granting a secure application role to the users
D
by implementing the Database Resource Manager plan
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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 executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs， so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".
考题
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
考题
Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；
考题
You work in a company which is named Wiikigo Corp. The company 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. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（） A、 DROP LOGIN "WIIKIGO/User1"; B、 EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';C、 EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; D、 CREATE LOGIN "WIIKIGO/User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO/User1";
考题
All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）A、all sessions of the HR user onlyB、all sessions of the HR user and the SYS userC、the session of the HR user that executed the commandsD、all the sessions for which the database users have access privilege to the PERSONS table
考题
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A、All sessions of the HR user onlyB、All sessions of the HR user and the SYS userC、The session of the HR user that executed the commandsD、All the sessions for which the database users have access privilege to the PERSONS table
考题
You work as a database administrator for Certkiller .com. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.
考题
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 created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
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
考题
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）A、set the SESSIONS to 1 in the parameter fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
考题
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;
考题
单选题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
考题
单选题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
考题
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A
All sessions of the HR user onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
考题
单选题All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）A
all sessions of the HR user onlyB
all sessions of the HR user and the SYS userC
the session of the HR user that executed the commandsD
all the sessions for which the database users have access privilege to the PERSONS table
考题
单选题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 created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A
The command produces an error.B
The profile is dropped and current user sessions use the DEFAULT profile immediately.C
The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D
The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
单选题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
考题
单选题You executed the following command in the lsnrctl utility to stop the listener： lsnrctl STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A
It terminates all user sessions.B
It prevents users from logging in to the database remotely.C
It halts the server until all user transactions are completed.D
The server hangs， so users will receive an error asking them to login again.E
Connected users would get an error with the message End of communication channel.
考题
单选题You work in a company which is named Wiikigo Corp. The company 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. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）A
DROP LOGIN WIIKIGO/User1; B
EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';C
EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; D
CREATE LOGIN WIIKIGO/User1 FROM Windows;DENY CONNECT SQL TO WIIKIGO/User1;
考题
单选题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.
考题
单选题Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）A
User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；B
User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；C
User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；D
User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；E
User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；
考题
单选题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.
考题
单选题The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）A
set the SESSIONS to 1 in the parameter fileB
grant SINGLE SESSION privilege to all of the usersC
set the SESSIONS_PER_USER to 1 in the users’ profileD
grant RESTRICTED SESSION privilege to all of the database usersE
create a role with SINGLE SESSION privilege and assign the role to the users
考题
单选题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；
热门标签
最新试卷
