Database-Oracle [3i Infotech Placement]: Sample Questions 23 - 24 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 23

Oracle
Edit

Statement

True-False▾

SMON process is used to write into LOG files

Answer

FALSE

Explanation

Process Monitor Process
  • The Shared Global Area is where SMON process runs.
  • When redo log buffer is full then SMON with the help of LOGWRITER writes into log files

    Shared Global Area

  • SGA is a shared memory structure with SGA components.
  • Contains data and control information for one oracle database.

SMON

  • SMON background process performs all system monitoring functions on the oracle database.
  • Each time oracle is re-started, SMON performs a warm start and recoveres transactions left incomplete at the last shut down.
  • Performs periodic cleanup of temporary segments no longer needed.
  • Performs recovery, if necessary, at instance startup.
  • Responsible for cleaning up temporary segments that are no longer in use.
  • Checks regularly to see whether it is needed.

Question 24

Oracle

Question

MCQ▾

Transactions per rollback segment is derived from …

Choices

Choice (4)

a.

Complex snapshots

b.

Db_Block_Buffers

c.

None of the above

d.

All of the above

Answer

a.

Explanation

The Rollback Segment
  • Complex snapshots contain at least any one of the GROUP BY clause, CONNECT BY clause, JOIN, sub-query or snapshot of operation.
  • Transactions per rollback segment are derived from complex snapshots.
  • The transaction load on the system is the number of rollback segments.
  • Rollback filers are associated with large transaction.
  • The sizing of rollback segments depends on many factors like the size of the average transaction, the size of the large transaction, and the available space.

Developed by: