What is an oracle database schema?
When will be a segment released?
How many Dispatcher Processes are created?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is Database Buffers ?
What are disadvanteges of having raw devices ?
Why query fails sometimes ?
How will you estimate the space required by a non-clustered tables?
What are the functions of SMON?
what is ORACLE MEMORY STRUCTURES
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is the function of Lock (LCKn) Process?
What is meant by redo log buffer ?