Which of the following components comprise an oracle architecture?

Options
- Database related background processes
- Tablespaces
- Datafiles
- All of the above


CORRECT ANSWER : All of the above

Discussion Board
Oracle Architecture

Background processes : To maximize performance and accommodate many users, a multiprocess Oracle Database system uses background processes. Background processes consolidate functions that would otherwise be handled by multiple database programs running for each user process. Background processes asynchronously perform I/O and monitor other Oracle Database processes to provide increased parallelism for better performance and reliability.

Tablespaces : A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments.

Datafiles : They are physical structures that conform to the operating system in which Oracle is running. A database's data is collectively stored in the datafiles that constitute each tablespace of the database.

Prajakta Pandit 02-16-2017 05:59 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement