Oracle Admin Interview Question and Answers

1. What is the difference between database and instance?
  Database is the collection of data files that contain the information of interest; whereas instance is the combination of background processes and memory structure.
 
Your Name Your Email-ID
Your Answer
2. What are the disk components?
 
  • Data files
  • Redo Logs
  • Control files
  • Password files and
  • Parameter files
    • are the disk components.
 
Your Name Your Email-ID
Your Answer
3. What is Database Writer (DBWR)?
  DBWR is a background process that writes changed data blocks from buffer cache to the data file. The changed data blocks are called dirty blocks.
 
Your Name Your Email-ID
Your Answer
4. What is the logical structure of the disk resource?
  Following is the logical structure of the disk resources:
  • Data block – Refers to the smallest logical storage unit. Size of a data block is a multiple of operating system block size.
  • Extent – Refers to the contiguous set of data blocks, which is allocated as a unit to a segment.
  • Tablespace – Refers to the final logical storage unit. It is mapped to physical data file.
  • Segment – Allocates a logical structure, such as table. It is a set of extents, which are stored in the same tablespace.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 1 of 10