A connection pooling configuration where several

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 7: What is the new Oracle Shared Server? A. An improved version of multithreaded server configuration B. A connection pooling configuration where several clients are connected to the same server process. C. Two or more database servers, which share data by means of database links; the client software is unaware to which server it is connected D. A configuration of Real Application Clusters where the client connection is routed to the least busy instance. Answer: A Explanation: Oracle Shared Server is an improved version of multithreaded server configuration. Incorrect Answers B: Oracle Shared Server does not provide configuration where several clients are connected to the same server process. C: Oracle Shared Server does not include two or more database servers, which share data by means of database links. D: Oracle Shared Server is not a configuration of Real Application Clusters where the client connection is routed to the least busy instance. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 144-152 Chapter 3: Manageability Enhancements Actualtests.com - The Power of Knowing 1Z0-030 Oracle 9i New Features, Robert Freeman, p. 59-60 Chapter 2: Oracle9i Architecture Changes QUESTION 88: The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in the INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which objects will be exported by this command? exp system/manager tablespaces=SAMPLE A. Only the EMPLOYEES table B. Only the EMPLOYEES table and its corresponding primary key index C. The EMPLOYEES table and partition P1 D. The EMPLOYEES table, IPK_EMP index, and the SALES table Answer: D Explanation: The EMPLOYEES table, IPK_EMP index, and the SALES table will be exported by this command, because Export utility export objects in the SAMPLE tablespace and ALL other objects corresponding to objects in the SAMPLE tablespace: other partitions for table from SAMPLE tablespace, primary key, other corresponding indexes and so on. Incorrect Answers A: Not only the EMPLOYEES table will be exported, but all objects corresponding to it also. B: All other partitions of the EMPLOYEE table will be exported also. C: Its corresponding primary key index will be exported also. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 49-51 Chapter 2: Availability Enhancements QUESTION 89: Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY, what is its effect? A. The Advisory is on and will capture both CPU and memory overhead. B. The Advisory is on but the memory for the Advisory is not allocated. C. The Advisory is off and the memory for the Advisory is not allocated. D. The Advisory is off but the memory for the Advisory remains allocated. Answer: D Actualtests.com - The Power of Knowing 1Z0-030 Explanation: You must instruct Oracle...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online