Oracle 11g dba questions for freshers and experienced continued

1
Oracle 11g dba questions for freshers and
experienced continued

• Q. Distinction between SGA and PGA
• Answer
• SGA (System Global Area) is a storage place
  assigned during the set up of an instance.
• SGA is assigned as 40 of RAM dimension by
  standard.
• SGA dimension is managed by DB_CACHE_SIZE
  parameter described in initialization parameter
  file (init.ora details file or SPFILE).

2

• What are the hard drive elements in Oracle?
• Answer
• These are the actual elements which gets saved in
  the hard drive.
• Data files
• Upgrade Log files
• Control files

3

• What is System Change Number (SCN)?
• Answer
• SCN is a exclusive ID that Oracle produces for
  every dedicated deal.
• It is documented for every alternation in the
  redo access.
• SCN is also produced for every checkpoint
  (CKPT) happened.

4

• What is Database Writer (DBWR) and when does DBWR
  create to the data file?
• Answer
• DBWR is experience procedure that makes details
  prevents details from Databases shield storage
  cache to details.
• - There are 4 essential circumstances when DBWR
  makes to details file
• Every 3 seconds

5

• Which Table spaces are designed instantly when
  you build a database?
• Answer
• SYSTEM tablespace is designed instantly during
  database development.
• It will be always on the internet when the
  database is start.

6

• Thank You