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.
“why do you want to join us? “ “ When can you join us ? “ “ How do you come to know of this position? “
Viewing 2181 - 2190 interview questions