Choose three a the shmseg parameter controls the

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: Answer: A QUESTION 29: Which three statements are true about the functions of the shared memory parameters? (Choose three.) A. The shmseg parameter controls the minimum number of segments that must be available to a process. B. The shmmni parameter controls the maximum number of semaphore sets. C. The shmseg parameter controls the maximum number of shared memory segments that can be attached to a process. D. The shmall parameter controls the maximum amount of shared memory that may be in use at any time. E. The shmall parameter controls the maximum size of each shared memory segment. F. The shmmni parameter controls the maximum number of shared memory segments. Actualtests.com - The Power of Knowing 1Z0-036 Answer: C,D,F QUESTION 30: Examine the following setting that you make while installing Statspack: d default_tablespace='SYSTEM' Which statement about this setting is true? A. With this setting, the installation configures the Statspack environment. To complete the installation, run the spcreate script with SYSDBA privileges. B. With this setting, the installation places the required packages in the SYSTEM tablespace. To access the Statspack, you must log on as the PERFSTAT user. C. With this setting, Statspack stores the performance statistics in the SYSTEM tablespace. To view the reports, you must log on to Oracle Enterprise Manager as the PERFSTAT user. D. With this setting, the installation fails. To fix the installation, first run the spdrop script and then the spcreate script with SYSDBA privileges. E. With this setting, the installation fails. To fix the installation, first run the spdrop script and then the spcreate script as the PERFSTAT user. Answer: D QUESTION 31: You are managing a data warehouse on an Oracle 9.2 installation. The datafiles are on ext3 file system. You have enabled asynchronous input/output (I/O) for Oracle server. Which tuning parameter would you use to improve I/O throughput at the Linux operating system (OS) level? A. fs.aio-max-nr B. fs.aio-max-pinned C. fs.aio-nr D. fs.aio-max-siz...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online