I wasn't asked this question but it came up. With an Internet facing application, it would make more sense to move from single node databases to clustered databases. A single node Oracle database has to be shutdown to perform upgrades and some patches. With an Oracle RAC cluster , rolling upgrades can be performed while still maintain 100 percent uptime. It seems management is favorable to this move but it just doesn't seem to be a priority.
How to resolve performance issues?
What is the CAP theory meaning?
Replication, Sharading and Performance ?
It was mostly from sql and join and acid property other basic question .Basic query are asked.the standard question of finding the second highest marks.it was two round of interview lasted for 30 minutes each.
Mostly Technical questions related to Database Internals, optimization and management and how to handle database during different scenarios.
Fixing performance issues and implementing features, system design, reading query plan and statistics
Architecture , internals including the commands
Normalization Select Window Functions How would I manage financial database
What is git blame for?
Viewing 2461 - 2470 interview questions