DDL ,DML questions ,truncate ,drop def
Database Consultant Interview Questions
5,240 database consultant interview questions shared by candidates
Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines. Responsible for database refresh and coordinating with QA Team. Proactive monitoring of SQL server known issues related to performance. Writing Custom scripts to refresh tables and monitoring jobs. Troubleshooting performance issues in production and non-production servers. Providing support for database mirroring, always on and log shipping implementation.
Technical question on DBMS management
Tell a little about yourself
salary expectations
Interpreting some SQL. Nothing challenging.
What is the difference between inner and outer join?
Import and export
Puzzle "Three Light Bulbs & Switches in a Room": A windowless room contains three identical light fixtures, each containing an identical light bulb or light globe. Each light is connected to one of three switches outside of the room. Each bulb is switched off at present. You are outside the room, and the door is closed. You have one, and only one, opportunity to flip any of the external switches. After this, you can go into the room and look at the lights, but you may not touch the switches again. How can you tell which switch goes to which light?"
What was the reason of leaving the old employer
Viewing 981 - 990 interview questions