Friday, January 25, 2013

Oracle PSR Interview questions continued

http://www.oracle.com

Oracle PSR Interview questions:

1) Process states (Kernal and User process in running and waiting state)
2) Interrupts
3) Web Server performance tuning
4) Valid XML and Invalid XML
5) SQL server:  How would you handle WHERE condition in non index column in terms of performance tuning ?
6) XML parsing:  DOM processor memory or CPU issue
7) Linx command to find memory info and processor info 
8) IIS web server performance tuning
9) SOUNDEX in SQL server
10) Public key and Private key in encryption concept
11) What is Amdahl's law ?
12) How will you performance tune a website ?
13) How will you utilize CPU in a situation where increasing the load doesn't increase the CPU utilization and the application is very slow.  (Thread pool - increase)
14) Thread, Mutex, Semaphore.
15) Sealed class and abstract class
16) What is JDBC connection pool ?  Advantage and disadvantage of the connection pools
17) Race condition in java
18) Process vs Thread
19) Program vs Process
20) What is Critical section ?

No comments:

Post a Comment