单选题Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）AYou would configure more listeners for the database.BYou would configure the database in shared server mode to use the connection pooling feature.CYou would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.DYou would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
单选题
Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）
A
You would configure more listeners for the database.
B
You would configure the database in shared server mode to use the connection pooling feature.
C
You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D
You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
参考解析
解析：
暂无解析
相关考题：
You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A、The instance would normally abort.B、The instance would not be affected.C、The instance would be invalid， so would have to be aborted.D、The instance would remain open， but the LGWR process would fail.E、The instance would remain open and would automatically create the missing file
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state， but all the background processes will be restarted.
For which database operation would you need the database to be in the MOUNT state（）A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A、Oracle Migration AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）A、the V$LOG viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、mount the new disk group in the ASM instanceB、restart the ASM instance and the production database instanceC、register the new disk groups in the production database instanceD、restart the ASM instance without restarting the production database instanceE、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）A、The extents in the undo tablespace retain data until the next full database backup.B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
多选题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area for DML and DDL StatementsELocation of a part of the runtime area for SELECT statements
单选题For which database operation would you need the database to be in the MOUNT state（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）Astatistics recommendationsBSQL profile recommendationsCindex-related recommendationsDrestructuring of SQL recommendations
单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）AThe instance would hang.BThe instance needs to be shut down.CThe instance would be in the open state.DThe instance would abort in such cases.EThe instance would be in the open and invalid state.FThe instance would in the open state， but all the background processes will be restarted.
单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A mount the new disk group in the ASM instanceB restart the ASM instance and the production database instanceC register the new disk groups in the production database instanceD restart the ASM instance without restarting the production database instanceE include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
单选题Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
单选题You work as a database administrator for Supportcenter.cn. 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.
单选题The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of information statically configured within listener.ora. In order to support this， which tool could be used to configure the listener statically？（）AOracle Net ManagerBListener Control UtilityCOracle Net Control UtilityDOracle Net Configuration Assistant
单选题In which situation would you use static database registration for a listener（）Awhen multiple databases are to be registered with the listenerBwhen DBAs need to connect remotely to start up the database instanceCwhen users need to connect the database instance using the host naming methodDwhen the database instance that is to be registered with the listener is configured in shared server mode
单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）AThe instance would normally abort.BThe instance would not be affected.CThe instance would be invalid， so would have to be aborted.DThe instance would remain open， but the LGWR process would fail.EThe instance would remain open and would automatically create the missing file
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
单选题You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）ASet DB_FLASH_CACHE_SIZE=64GBSet D3_FLASH_CACHE_SIZE=64G, 64GCSet D3_FLASK_CACKE_SI2E=128GDdb_flash_cache_SI2E is automatically configured by the instance at startup
多选题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control