Oracle Dba Interview Question and Answers

36. What is Oracle Applications technology layer?
 
  • Oracle Applications technology layer provides common basic functionality across all Oracle Applications product families.
  • The Oracle Applications technology layer is a collection of products whose functionality is used by all the modules of Oracle Applications.
 
Your Name Your Email-ID
Your Answer
37. What is concurrent processing server?
  When an Oracle Application user submits a request to run a program, it’s called concurrent requests. Concurrent manager are the programs responsible for running the concurrent requests. Concurrent requests are processed from concurrent processing server.
 
Your Name Your Email-ID
Your Answer
38. What in Streams pool in Oracle 10g?
  Streams pool is a part of System Global Area (SGA) from which memory for streams is allocated if it is configured. It can be configured by specifying initialization parameter STREAMS_POOL_SIZE.
 
Your Name Your Email-ID
Your Answer
39. What are the different types of memory structure available in Oracle?
 
  • System Global Area(SGA)
  • Program Global Area(PGA)
  • are the different types of memory structure available in Oracle.
 
Your Name Your Email-ID
Your Answer
40. What is the primary duty of the DBA?
  The primary duty of the DBA is to protect the database and provide continuous access to that data for the user community.
 
Your Name Your Email-ID
Your Answer