网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
热门标签
最新试卷