One of the user sessions was terminated abnormally in the mi

第1题：

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 Session
• B、A single Control Connection and multiple Sessions(one pers ubscriber)
• C、Multiple Control Connections and a single Session
• D、Multiple Control Connections and multiple Sessions(one per subscriber)

第2题：

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 file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第3题：

第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.

第5题：

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.

第6题：

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 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

第7题：

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.

第8题：

第9题：

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

第10题：

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.