Middle level Questions were asked.
Database Coordinator Interview Questions
5,217 database coordinator interview questions shared by candidates
something like, what are the Oracle background process and their functions? What's the difference between ref cursor and cursor etc?
explainn DBMS
What is git blame for?
Normalization Select Window Functions How would I manage financial database
Sql all type questions joins cte union all etc
Replication, Sharading and Performance ?
none. please note this was for an experience position.
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?
Viewing 3661 - 3670 interview questions