单选题In which situation would you use the Oracle Shared Server configuration?()Awhen performing export and import using Oracle Data PumpBwhen performing backup and recovery operations using Oracle Recovery ManagerCwhen performing batch processing and bulk loading operation in a data warehouse environment Din an online transaction processing (OLTP) system where large number of client sessions are idle most of the time

单选题
In which situation would you use the Oracle Shared Server configuration?()
A

when performing export and import using Oracle Data Pump

B

when performing backup and recovery operations using Oracle Recovery Manager

C

when performing batch processing and bulk loading operation in a data warehouse environment 

D

in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time


参考解析

解析: 暂无解析

相关考题:

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?() A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

Which are required initialization parameters in an Oracle Shared Server environment?()A、DISPATCHERS and SHARED_SERVERSB、DISPATCHERS and MAX_DISPATCHERSC、MAX_DISPATCHERS and MAX_SHARED_SERVERSD、SHARED_SERVER_SESSIONS and DISPATCHERS

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  A、 MMANB、 PMONC、 MMOND、 MMNL

You are configuring for Oracle Shared Server. Which service is required? ()A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal?()A、Named PipesB、TCP/IPC、Shared MemoryD、Virtual Interface Adapter (VIA)E、Multiprotocol

Which of the following options would you choose to implement controlled access using remote authentication for your networks?()A、OiDB、RADIUSC、Wallet ManagerD、Oracle Names Server

Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()A、 If you select a non-XA JDBC driver, you can use WebLogic AQ JMS in both local  global transactionsB、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSC、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerD、 If you select an XA JDBC driver, you can use WebLogic AQ JMS in both local and global transactions

You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?()A、 streams poolB、 shared poolC、 log bufferD、 keep buffer cacheE、 recycle buffer cache

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A、 use DBMS_IJOB packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import

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

Which statement is true regarding Oracle Shared Server architecture?()A、A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B、Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.C、Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. D、Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility

Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener?()A、 Oracle Net ManagerB、 Listener Control utilityC、 Database Configuration AssistantD、 Oracle Net Configuration Assistant

Your network contains a server that runs Windows Server 2008 R2.You need to enable access-based enumeration (ABE) on a shared folder.Which console should you use?()A、Disk ManagementB、File Server Resource ManagerC、Share and Storage ManagementD、Storage Explorer

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?()A、 Named Pipes B、 TCP/IP C、 Shared Memory D、 Virtual Interface Adapter (VIA) E、 Multiprotocol

单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()ASYSTEM BOUTLN CINTERNAL DSYS

多选题Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()AIf you select a non-XA JDBC driver, you can use WebLogic AQ JMS in both local  global transactionsBOracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSCOracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerDIf you select an XA JDBC driver, you can use WebLogic AQ JMS in both local and global transactions

单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import

单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener?()A Oracle Net ManagerB Listener Control utilityC Database Configuration AssistantD Oracle Net Configuration Assistant

单选题Which are required initialization parameters in an Oracle Shared Server environment?()ADISPATCHERS and SHARED_SERVERSBDISPATCHERS and MAX_DISPATCHERSCMAX_DISPATCHERS and MAX_SHARED_SERVERSDSHARED_SERVER_SESSIONS and DISPATCHERS

单选题Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area (UGA) information and improve the shared pool performance?()Alarge poolBstreams poolCkeep buffer cacheDrecycle buffer cache

单选题You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle Connection Manager to filter client requests.  Which naming method can you use?()AOnly hostBOnly localCEither host or localDBoth host and local

单选题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()A MMANB PMONC MMOND MMNL

单选题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

单选题Which statement is true regarding Oracle Shared Server architecture?()AA dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. BUnder the Oracle Shared Server architecture, client-user processes connect to shared user processes.CEach dispatcher has its own request queue, which is monitored every three seconds by the dispatcher. DOracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

单选题In which situation would you use the Oracle Shared Server configuration?()Awhen performing export and import using Oracle Data PumpBwhen performing backup and recovery operations using Oracle Recovery ManagerCwhen performing batch processing and bulk loading operation in a data warehouse environment Din an online transaction processing (OLTP) system where large number of client sessions are idle most of the time

单选题You are configuring for Oracle Shared Server. Which service is required? ()AOracle Net ServiceBOracle HTTP ServiceCOracle Paging ServiceDInternet Directory Service