Oracle Admin Interview Question and Answers

33. What is the PGA_AGGREGRATE_TARGET parameter?
 
  • The PGA_AGGREGATE_TARGET parameter specifies the target aggregate PGA memory available to all server process attached to an instance.
  • This parameter is used to set overall size of work area required by various components.
  • A non zero value of this parameter is equivalent to setting WORKAREA_SIZE_POLICY parameter to AUTO.
  • In this case, you do not need to specify individual *_AREA_SIZE parameter values.
 
Your Name Your Email-ID
Your Answer
34. When does LGBR write to the log file?
  Followings are the situations when LGBR writes to the log file:
  • When a user process commits a transaction
  • When redo log buffers is one third full
  • When more than a megabyte of changes are recorded into the redo log buffer
  • Before DBWR writes modified blocks to the data files.
 
Your Name Your Email-ID
Your Answer
35. What happens during startup mount?
  In case of startup mount, the parameter and control files can be read but the data files and the log files cannot be accessed because database is not yet open. Generally, this mode is used when a data file recovery is required.
 
Your Name Your Email-ID
Your Answer
36. Can you pivot the results of a query?
  You can use hierarchical query with the sys_connect_by_path function in Oracle 9i and above to pivot the result.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 9 of 10