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.
Dba Interview Questions
3,455 dba interview questions shared by candidates
explainn DBMS
How to resolve performance issues?
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.
Instance recovery process?
Data guard basics ?
Mostly Technical questions related to Database Internals, optimization and management and how to handle database during different scenarios.
Why was I looking to work for BD
log shipping, mirroring, clustering, Always on
It's was good interview where interviewer covered all aspect of SQL Server admin, from DR to HA to SQL Security, replication, Mirroring, Log shipping, Database architecture etc.
Viewing 2461 - 2470 interview questions