what are the types of connection load-balancing?
What is fill factor? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the differnce between process and thread ?
What is blocking and how would you troubleshoot it?
what is a user-defined lock?
Give two methods you could use to determine what DDL changes have been made.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is logical system in sap basis
how can you communicate with operating system files from oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is checkpoint?
wat is global index and local indes