Oracle Database Interview Questions Set-2

 1-How many Shared Servers Maximum Per Instance we can Configure?

Answer-Unlimited

2- How many Dispatchers Maximum Per Instance we can Configure?

Answer-Unlimited

3-How many Parallel Execution Slaves Maximum Per Instance?

Answer-Unlimited

4-How many Backup Sessions Maximum Per Instance?

Answer-Unlimited

5-How many Services Maximum per Instance?

Answer-8200

6-How many Indexes Maximum Per Table we can Create?

Answer-Unlimited

7-How many Columns Per Table we can Create?

Answer-1000 Columns

8- How many Columns Per Index we can Create?

Answer-32 Columns

9- How many Columns Per Cluster Index we can Create?

Answer-32 Columns

10-How many Constraints Maximum Per Column we can Create?

Answer-Unlimited

Read the following article series for Interview Questions.

https://www.oracleride.com/oracle-database-interview-questions-set-1/

Cheers!!!!

With Best Wishes!!!!

Ahmad

Oracle Consultant

OCE (11gR2 RAC)

OCP (11gR2/10gR2/9iR2)

OracleRide Team!!!!