单选题Development of real-time event-driven applications using Coherence is supported b（）Athe Partitioned CacheBthe Local CacheCthe Map Listener running within a Partitioned CacheDthe Map Listener running within an application 

第1题：

A financial customer has three data centers that are four kilometers apart. Their SAP application data needs to be kept synchronized within 10 milliseconds.  Which solution satisfies the customer’s recovery time objective（）

• A、DS8700 systems at each site running Metro Mirror
• B、DS8700 systems at each site running Global Mirror
• C、DS5300 systems at each site running Global Mirror
• D、XIV systems at each site running Remote Mirroring

第2题：

ABC Company has approximately 150’000 products in their catalog and wants to put these within a Coherence cache to improve performance and access times of their existing JEE application without too much change to existing code. There are a number of servlets that get the same product information multiple times within a page. There are also a number of server-based processes that run at regular intervals and also request product information many times. Products have small changes which need to be updated during the day.  What would be the most appropriate caching scheme to use ？ （）

• A、 Near Cache
• B、 Distributed Cache
• C、 Local Cache
• D、 Replicated Cache

第3题：

our 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 Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第4题：

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

第5题：

Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using 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.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

• A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
• E、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

第14题：

You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

• A、It would attempt to start the default listener
• B、It would start the most recently created listener.
• C、It would display an error with a message asking for the listener name to be specified.
• D、It would show you a list of listeners and prompts for the listener name that you want to start.

第15题：

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？（）

• A、Oracle Net Manager
• B、Listener Control Utility
• C、Oracle Net Control Utility
• D、Oracle Net Configuration Assistant

第16题：

In a shared server configuration， which two describe the actions that the listener can take to service a client request？（）

• A、The listener hands the connection request directly to a dispatcher. 
• B、A dedicated server inherits the connection request from the listener. 
• C、The client connects to a dedicated server directly using a protocol address provided by the listener. 
• D、The application initiating the session spawns a dedicated server process for the connection request. 
• E、The listener issues a redirect message to the client, containing the protocol address of a dispatcher. The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message. 

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：