Oracle Database Questions and Answers - Oracle Database 1. Architecture. This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Oracle Database 1. Architecture”. 1. What is the use of Library cache? Contains User information, such as user privilegesb) Used to store shared SQLc) Log of changes made to the databased) All of the Mentioned. View Answer. Answer: b. Explanation: Oracle Library cache is like a data buffer cache, except that it is not for data, but a cache for SQL PL/SQL programs and Java classes. Which processes is an instance made of Oracle? Oracle background processesb) Memory processesc) Data processesd) All of the Mentioned. Current File (2) 2014/10/28 2014/11/12 John Wiley & Sons Information Technology & Software Development Adobe Creative Team. Adobe Press Digital Media. Express Helpline- Get answer of your question fast from real experts. 9781402090837 1402090838 Towards Mathematical Philosophy, IV - Papers from the Studia Logica Conference Trends in Logic, David Makinson, Jacek Malinowski, Heinrich. ![]() View Answer. Answer: a. Explanation: Oracle creates a set of background processes for an instance to manage memory structure, asynchronously perform I/O to write data to disk, and do general maintenance tasks. Which of the following segment is destroyed when the SQL statement is finished? Data Segmentb) Object Segmentc) Temporary Segmentd) All of the Mentioned. View Answer. Answer: c. Explanation: After each block is formatted/finished, the new index keys are put in a sort (temporary) segment. What is the use of an index? Retrieve data more quickly and efficientlyb) Related data requires much less I/O overhead if accessed simultaneouslyc) Simplify the user’s perception of data accessd) All of the Mentioned. View Answer. Answer: a. Explanation: Index is used for to perform the quick operation on the data. Which of the following components comprise an Oracle architecture?
Database related background processesb) Tablespacesc) Datafilesd) All of the Mentioned. View Answer. Answer: d. Explanation: Oracle architecture consists of DB process, Table space, Datafiles. What is the use of extent in Oracle? Stores user data within the databaseb) Stores rollback information used when data must be rolled backc) Minimize the amount of wasted (empty) storaged) None of the Mentioned. View Answer. Answer: c. Explanation: An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks. Which area of PGA stores binding variables and run- time buffers information? SQL areab) Private SQL areac) Stack spaced) Session area. View Answer. Answer: b. Explanation: PGA (Program Global Area) is a non- shared memory region that contains data and control information exclusively for use by an Oracle process. The PGA is created by Oracle Database when an Oracle process is started. All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace. In Oracle, which of below are types of segments? Permanent Segmentb) Object Segmentc) Data Segmentd) All of the Mentioned. View Answer. Answer: c. Explanation: Oracle has 4 type of data segment : 1)data segments 2)index segments 3)rollback segments 4)temporary segments. The redo log buffer and Shared pool are elements of? PGAb) Buffer cachec) PGA and Buffer cached) SGAView Answer. Answer: d. Explanation: SGA (System Global Area) contains Shared Pool, Database Buffer Cache, Java Pool, redo Log Buffer. Sanfoundry Global Education & Learning Series – Oracle Database. Here’s the list of Best Reference Books in Oracle Database. To practice all areas of Oracle Database, here is complete set of 1. Multiple Choice Questions and Answers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
August 2017
Categories |