Database

Oracle Database Interview Questions Set-5

1-What is Database file Maximum size? Answer- Operating system dependent 2-What is MAXEXTENTS Default value? Answer- Derived from tablespace default storage or DB_BLOCK_SIZE initialization parameter 3- What is MAXEXTENTS Maximum value? Answer- Unlimited 4- Maximum number of Redo Log Files per Database? Answer- Limited by value of MAXLOGFILES parameter in Read more…

Database

Oracle Database Interview Questions Set-3

1-Maximum levels of Subqueries in a SQL statement we can write? Answer-Unlimited in the FROM clause & 255 Subqueries in the WHERE clause 2-Maximum length of linear partitioning key in Per Partition? Answer-4 KB (overhead) 3-Maximum number of columns in partition key in Per Partition? Answer-(1024K – 1) 4-Maximum number Read more…

Database

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 Read more…