- How free extents are managed in Ver 6.0 and Ver 7.0
- What is Database Buffers
- What is the OPTIMAL parameter
- What is meant by recursive hints
- How will you monitor the space allocation
- What is a Rollback segment entry
- What is use of Rollback Segments in Database
- What is the role of PCTFREE parameter in Storage clause
- What is meant by redo log buffer
- List the Optional Flexible Architecture (OFA) of Oracle database
- What is meant by free extent
- List the factors that can affect the accuracy of the estimations
- What is the functionality of SYSTEM table space
- How will you create multiple rollback segments in a database
- What is advantage of having disk shadowing/ Mirroring
- Which parameter in Storage clause will reduce no. of rows per block
- How will you monitor rollback segment status
- How does Space allocation table place within a block
- Why query fails sometimes
- What is dictionary cache
- What is meant by Redo Log file mirroring? How it can be achieved
- What is the significance of having storage clause
- What are the disadvantages of having raw devices
- How can we plan storage for very large tables
- When will be a segment released
- How will you force database to use particular rollback segment
- What is a Control file
- How the space utilization takes place within rollback segments
- How will you estimate the space required by non-clustered tables
- How will you swap objects into a different table space for an existing database
- How to implement the multiple control files for an existing database
- What is hit ratio
- What are the components of SGA
- What is Shared Pool
- What are the two types of Server Configurations
- What is the function of Lock (LCKn) Process
- What are functions of PMON
- What is the maximum number of Lock Processes used
- What is the function of Dispatcher (Dnnn)
- What does LGWR do
- What is User Process
- What is a Parallel Server option in ORACLE
- When does LGWR write to the database
- What is PGA
- What is SGA
- When Does DBWR write to the database
- What Does DBWR do
- What do Redo Log Buffers contain
- Name the ORACLE Background Process
- What is function of RECO
- What is the function of checkpoint (CKPT)
- What constitute an ORACLE Instance
- How many Dispatcher Processes are created
- What is Server Process
- What are the functions of SMON
- What is the function of ARCH
- What is Shared SQL Area
- What is a Multi-threaded Server Configuration
- Job Opening with a TOP IT Company in Pune location