I was asked to prepare a 15-minute presentation covering several topics related to Oracle databases. This was the deciding stage to grant or deny the job offer.
Database Administrator Interview Questions
3,442 database administrator interview questions shared by candidates
If you have an application hitting a database and you have no access to the source code for that application and you need to figure out what tables it's using for a certain record, how would you do that?
What commands do you use to backup a mysql database?
About my experience especially in previous migrations
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
Why did you choose IBI Group?
What RDBMS systems do you manage?
How do you setup a clustered instance, what you need to do?
What aspects of the job do you like?
general behavioral Qs
Viewing 181 - 190 interview questions
See Interview Questions for Similar Jobs
Database AnalystDatabase ManagerData EngineerOracle DbaData AnalystDatabase EngineerDatabase AdminBusiness Intelligence ConsultantSql DeveloperNetwork AdministratorData Warehouse ArchitectMachine Learning ScientistDatabase DeveloperSystem AdministratorMining EngineerData Warehouse ManagerDba ManagerAb Initio DeveloperDatabase Architect