Solved MCQ of Oracle and Distributed Databases set-3
1. The …………………… consists of physical files and memory components. A) Oracle Client B) Oracle Server C) Oracle Middleware D) Oracle Instance 2. The ……………………… consists of the memory components of Oracle and various background processes. A) Oracle Parameter B) Oracle Profile C) Oracle Process D) Oracle Instance 3. The Oracle Instance is made up of the ………………………. and the background processes. A) System Global Area (SGA) B) Oracle Global Area (OGA) C) Program Global Area (PGA) D) Private SQL Area (PSA) 4. The background processes of the Oracle instance are responsible for performing …………………. I/O functions. A) Synchronous B) Asynchronous C) Both of the above D) None of the above 5. The PGA is used to process ………………………… and to hold logon and other session information. A) SQL Statements B) Server Processes C) User Processes D) Shared Statements 6. In SGA, the contents of the memory area are shared by multiple users is called as ………………….. A) Redo Log Buffer B) Database Buffer Cache C) Shared