网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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 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 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".
考题
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying the username and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
考题
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（））；
考题
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.
考题
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 instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
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
考题
单选题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 instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying theusername and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
单选题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 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.
考题
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying theusername and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
考题
单选题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.
考题
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying the username and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
考题
单选题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.
考题
单选题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
热门标签
最新试卷
