网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
A
uses undo data for roll forward
B
uses Flashback Log for recovery
C
uses online redo logs to roll back
D
uses undo data to roll back the transaction
E
uses Recovery Manager （RMAN） to roll back
F
uses the System Monitor （SMON） background process to perform instance recovery
参考答案
参考解析
解析：
暂无解析
更多 “单选题One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A uses undo data for roll forwardB uses Flashback Log for recoveryC uses online redo logs to roll backD uses undo data to roll back the transactionE uses Recovery Manager （RMAN） to roll backF uses the System Monitor （SMON） background process to perform instance recovery” 相关考题
考题
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()
A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile
考题
You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?()
A.A single Control Connection and a single SessionB.A single Control Connection and multiple Sessions(one pers ubscriber)C.Multiple Control Connections and a single SessionD.Multiple Control Connections and multiple Sessions(one per subscriber)
考题
You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?（）A、A single Control Connection and a single SessionB、A single Control Connection and multiple Sessions(one pers ubscriber)C、Multiple Control Connections and a single SessionD、Multiple Control Connections and multiple Sessions(one per subscriber)
考题
You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager （RMAN） to roll backF、Uses the System Monitor （SMON） background process to perform instance recovery
考题
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
考题
Which two statements are true regarding firewall user authentication?（） (Choose two.)A、When configured for pass-through firewall user authentication, the user must first open a connection to the Junos security remote network resource.B、When configured for Web firewall user authentication only, the user must first open a connection to the Junos security remote network resource.C、If a Junos security device is configured for pass-through firewall user authentication, new sessions are automatically intercepted .D、If a Junos security device is configured for Web firewall user authentication, new sessions are automatically intercepted.
考题
SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A、The User Global Area （UGA） is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.
考题
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started
考题
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.
考题
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、uses undo data for roll forwardB、uses Flashback Log for recoveryC、uses online redo logs to roll backD、uses undo data to roll back the transactionE、uses Recovery Manager （RMAN） to roll backF、uses the System Monitor （SMON） background process to perform instance recovery
考题
Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The sessions are terminated and the active transactions are rolled back.D、The sessions are not allowed to perform any operations till the listener is started.
考题
单选题You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A
Uses undo data for roll forwardB
Uses Flashback Log for recoveryC
Uses online redo logs to roll backD
Uses undo data to roll back the transactionE
Uses Recovery Manager （RMAN） to roll backF
Uses the System Monitor （SMON） background process to perform instance recovery
考题
单选题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
考题
单选题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
考题
单选题Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL STOP What would happen to the sessions that are presently connected to the database instance？（）A
The sessions are able to perform only queries.B
The sessions are not affected and continue to function normally.C
The active transactions are rolled back and the sessions get terminated.D
The sessions are not allowed to perform any operations till the listener is started.
考题
多选题Which two statements are true regarding firewall user authentication?（） (Choose two.)AWhen configured for pass-through firewall user authentication, the user must first open a connection to the Junos security remote network resource.BWhen configured for Web firewall user authentication only, the user must first open a connection to the Junos security remote network resource.CIf a Junos security device is configured for pass-through firewall user authentication, new sessions are automatically intercepted .DIf a Junos security device is configured for Web firewall user authentication, new sessions are automatically intercepted.
考题
单选题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 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.
考题
单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A
The sessions are able to perform only queries.B
The sessions are not affected and continue to function normally.C
The sessions are terminated and the active transactions are rolled back.D
The sessions are not allowed to perform any operations till the listener is started.
考题
单选题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 current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine
考题
单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）A
Setting a metric thresholdB
Implementing Database Resource ManagerC
Enabling resumable timeout for user sessionsD
Decreasing the value of the IDLE_TIME resource limit in the default profile
考题
单选题You have a Terminal Server that runs Windows Server 2008. You need to configure the server to end any sessions that are inactive for more than one hour. What should you do？（）A
From Terminal Services Manager， create a new group.B
From Terminal Services Manager， delete the inactive sessions.C
From Terminal Services Configuration， modify the RDP-Tcp settings.D
From Terminal Services Configuration， modify the User logon mode setting.
考题
单选题You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?（）A
A single Control Connection and a single SessionB
A single Control Connection and multiple Sessions(one pers ubscriber)C
Multiple Control Connections and a single SessionD
Multiple Control Connections and multiple Sessions(one per subscriber)
考题
单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）A
The User Global Area （UGA） is not configured.B
The sessions were started using the login name SYS.C
The sessions are running in the Automatic Shared Memory Management mode.D
The sessions are running in the automatic Program Global Area （PGA） memory management mode.
考题
单选题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
热门标签
最新试卷
