Oracle Database Interview Questions Set-1
1-Maximum number of Cluster Database Instances per Database we can create?
2- How many Row-level Locks can occur in Database?
3-How many Distributed Lock Manager can occur in Database?
Answer-Operating system dependent
4-What is the Maximum value of SGA in Database?
Answer-Operating system-dependent (2 to 4 GB for 32-bit operating systems & > 4 GB for 64-bit operating systems)
5-How many Advanced Queuing Processes Maximum per Instance?
6-How many Job Queue Processes Maximum per Instance?
7-How many I/O Slave Processes Maximum per Background Process (DBWR, LGWR)?
8-How many I/O Slave Processes Maximum per Backup session?
9-How many Sessions Maximum per Instance?
Answer-65536 (Limited by the PROCESSES and SESSIONS initialization parameters)
10-How many Global Cache Service Processes Maximum per Instance?
Read the following article series for Interview Questions.
With Best Wishes!!!!
OCE (11gR2 RAC)