1-What is Minimum Value of Database Block Size? Answer-2048 bytes (2 KB) (Must be a multiple of operating system physical block size) 2- What is Maximum Value of Database Block Size? Answer-32 KB 3- How many Database Blocks will be allocated in an initial extent of a segment? Answer-2 blocks 4- Read more…
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…
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…
1-Maximum number of Cluster Database Instances per Database we can create? Answer-Operating system-dependent 2- How many Row-level Locks can occur in Database? Answer-Unlimited 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 Read more…