单选题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
题目
By assigning profiles for the users
By implementing Fine-Grained Auditing （FGA）
By granting a secure application role to the users
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”相关问题
-
第1题：
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（））；
正确答案:E -
第2题：
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 only
- B、All sessions of the HR user and the SYS user
- C、The session of the HR user that executed the commands
- D、All the sessions for which the database users have access privilege to the PERSONS table
正确答案:C -
第3题：
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.
正确答案:A -
第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 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.
正确答案:A -
第5题：
单选题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（）Aby assigning profiles for the users
Bby implementing Fine-Grained Auditing （FGA）
Cby granting a secure application role to the users
Dby implementing the Database Resource Manager plan
正确答案： A解析： 暂无解析 -
第6题：
单选题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（）AAll sessions of the HR user only
BAll sessions of the HR user and the SYS user
CThe session of the HR user that executed the commands
DAll the sessions for which the database users have access privilege to the PERSONS table
正确答案： C解析： 暂无解析 -
第7题：
单选题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？（）AYou must have started the database instance in restricted mode.
BYou must have started the database instance inNORMALmode.
CYou must have started the database instance with server parameter file.
DYou must have started the database instance but must not have mounted.
EYou must have started the database instance but must not have opened.
正确答案： E解析： 暂无解析 -
第8题：
单选题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（）AThe database user OPS$SKD will be able to administer the database.
BThe authentication detail for the database user OPS$SKD is recorded in the password file.
CThe local operating system user SKD will be able to access the database instance without specifying theusername and password.
DThe database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
正确答案： B解析： 暂无解析 -
第9题：
单选题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？（）AIt terminates all user sessions.
BIt prevents users from logging in to the database remotely.
CIt halts the server until all user transactions are completed.
DThe server hangs， so users will receive an error asking them to login again.
EConnected users would get an error with the message End of communication channel.
正确答案： D解析： 暂无解析 -
第10题：
单选题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?（）ADROP LOGIN WIIKIGO/User1;
BEXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';
CEXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1';
DCREATE LOGIN WIIKIGO/User1 FROM Windows;DENY CONNECT SQL TO WIIKIGO/User1;
正确答案： A解析： 暂无解析 -
第11题：
单选题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？（）AUser user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；
BUser user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；
CUser user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；
DUser user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；
EUser user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；
正确答案： E解析： 暂无解析 -
第12题：
单选题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（）ABy assigning profiles for the users
BBy implementing Fine-Grained Auditing （FGA）
CBy granting a secure application role to the users
DBy implementing the Database Resource Manager plan
正确答案： A解析： 暂无解析 -
第13题：
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 only
- B、all sessions of the HR user and the SYS user
- C、the session of the HR user that executed the commands
- D、all the sessions for which the database users have access privilege to the PERSONS table
正确答案:C -
第14题：
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.
正确答案:C -
第15题：
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.
正确答案:C -
第16题：
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
正确答案:A -
第17题：
单选题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（）AThe database user OPS$SKD will be able to administer the database.
BThe authentication detail for the database user OPS$SKD is recorded in the password file.
CThe local operating system user SKD will be able to access the database instance without specifying theusername and password.
DThe database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
正确答案： C解析： 暂无解析 -
第18题：
单选题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 （）Aall sessions of the HR user only
Ball sessions of the HR user and the SYS user
Cthe session of the HR user that executed the commands
Dall the sessions for which the database users have access privilege to the PERSONS table
正确答案： A解析： 暂无解析 -
第19题：
单选题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?（）Aby granting a secure application role to the users
Bby creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
CBy creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
DBy Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
EBy implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
正确答案： E解析： 暂无解析 -
第20题：
单选题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？（）AYou must have change tracking enabled in your database
BYour database must be running in NOARCHIVELOG mode
CTo back up a tablespace，it must be in backup mode
DTo back up a tablespace，it must first be taken offline
正确答案： D解析： 暂无解析 -
第21题：
单选题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（）AThe database user OPS$SKD will be able to administer the database.
BThe authentication detail for the database user OPS$SKD is recorded in the password file.
CThe local operating system user SKD will be able to access the database instance without specifying the username and password.
DThe database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
正确答案： B解析： 暂无解析 -
第22题：
单选题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?（）Aby granting a secure application role to the users
Bby creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
CBy creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
DBy Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
EBy implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
正确答案： C解析： 暂无解析 -
第23题：
单选题Your database initialization parameter file has the following entry： SEC_MAX_FAILED_LOGIN_ATTEMPTS=3 Which statement is true regarding this setting？（）AIt drops the connection after the specified number of login attempts fail for any user.
BIt is enforced only if the password profile is enabled for the user.
CIt locks the user account after the specified number of attempts.
DIt drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
正确答案： A解析： 暂无解析