网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题In which situation would you use the Oracle Shared Server configuration?()A when performing export and import using Oracle Data PumpB when performing backup and recovery operations using Oracle Recovery ManagerC 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?()A SYSTEM B OUTLN C INTERNAL D SYS

考题 多选题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?()A DISPATCHERS and SHARED_SERVERSB DISPATCHERS and MAX_DISPATCHERSC MAX_DISPATCHERS and MAX_SHARED_SERVERSD SHARED_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?()A large poolB streams poolC keep buffer cacheD recycle 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?()A Only hostB Only localC Either host or localD Both 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()A when multiple databases are to be registered with the listenerB when DBAs need to connect remotely to start up the database instanceC when users need to connect the database instance using the host naming methodD when 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?()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.

考题 单选题In which situation would you use the Oracle Shared Server configuration?()A when performing export and import using Oracle Data PumpB when performing backup and recovery operations using Oracle Recovery ManagerC 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

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