What would you do if you were emailed with people asking why their queries are timing out or blocked?
Database Administrator Interview Questions
3,445 database administrator interview questions shared by candidates
Some of the questions that were in the written exam: (1)Draw an ER for an online restaurant management system (2)Explain the difference between drop,delete and truncate (3)What is data warehouse (4)What is data redundancy (5)Explain the difference between super key and candidate key (6)What is normalization and denormalization , BNCF? (7)What is transaction and explain ACID (8)Explain the difference between stored procedure,function and trigger Apart from this there were many SQL questions
The phone call didn't go into very much technical questions.
Do you have any experience with always on a salability.
High Availability and disaster recovery, backup and restore
technical, data base administration related
Sql queries, what is dbms
Questions varied from SQL Join types, to troubleshooting steps I would take in certain scenarios.
What could be the disadvantage of using CTE's? Why are cursors considered "bad"? This was a pretty straight forward DBA Interview - questions any Senior DBA would know the answers to.
Client technical interviewer was challenging, and asked me to create a script for a specific query scenario.
Viewing 2181 - 2190 interview questions
See Interview Questions for Similar Jobs
Database ManagerDatabase AnalystData EngineerDatabase EngineerOracle DbaMachine Learning ScientistNetwork AdministratorData Warehouse ManagerData AnalystMining EngineerAb Initio DeveloperDatabase ArchitectData Warehouse ArchitectDba ManagerSql DeveloperDatabase DeveloperSystem AdministratorDatabase AdminBusiness Intelligence Consultant