|
Microsoft Interview Questions (SQL)
|
|
List of SQL Server Developer interview questions,I tried to answer briefly here but be advised that these answers may not be complete and it will be better for you to go through text books, books online and other resources on the net.
Before you go for the interview, be prepared to explain the database design of one of your latest projects. Don't be surprised if the interviewer asks you to draw ER diagrams. Well, here are some questions for you. Hope this helps you prepare for your interview.
Wish you all the best in your job hunt! Feel free to email me (admin@emicrosoftinterview.com) 'interview questions' that you've faced.
|
| |
|
Define candidate key, alternate key, composite key.
|
|
A candidate key is one that can identify each row of a table uniquely
(Read More... )
Average Rating:  |
|
|
What's the difference between a primary key and a unique key?
|
|
Both primary key and unique enforce uniqueness of the column on which they are defined
(Read More... )
|
|
How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
|
|
One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
(Read More... )
|
|
What is denormalization and when would you go for it?
|
As the name indicates, denormalization is the reverse process of normalization. It's the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.
(Read More... )
|
|
What is normalization? Explain different levels of normalization?
|
|
In relational database theory, normalization is the process of restructuring the logical data model of a database to eliminate redundancy, organize data efficiently, and reduce the potential for anomalies during data operations to improve data consistency and future enhancements
(Read More... )
|
|
What is a transaction and what are ACID properties?
|
|
A transaction is a logical unit of work in which, all the steps must be performed or none
(Read More... )
|
|
Whar is an index? What are the types of indexes? How many clustered indexes can be created on a tabl
|
|
Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker
(Read More... )
|
|
What are the steps you will take to improve performance of a poor performing query?
|
|
This is a very open ended question and there could be a lot of reasons behind the poor performance of a query
(Read More... )
|
|
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
|
|
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated
(Read More... )
|
|
Stored procedure to generate a simple or complex random password
|
|
This procedure generates random passwords using RAND() function. It can be configured to generate a simple or a complex password
(Read More... )
|
|
|
|
|
|
|
|
 |
|
|
New Articles
Combinations in a character array.
Write a program that takes input a char array and outputs all the combinations of the characters in the character array.
Example: consier char array {'a','b','c'}
the output shouold be abc,cab,bac,acb,cba,bca that is all the combinations of characters 'a','b','c'.
N-Queen Problem.
Write a Program to solve N-Queen Problem.
Reverse a string
Reverse a string using recursive function
|
|
|
|
Most Popular Articles
Crazy Guy On The Airplane
A line of 100 airline passengers is waiting to board a plane. they each hold a ticket to one of the 100 seats on that flight.
What are your greatest weaknesses
Beware - this is an eliminator question, designed to shorten the candidate list. Any admission of a weakness or fault will earn you an âAâ for honesty, but an âFâ for the interview.
Question: Tell me about yourself.
Many candidates, unprepared for the question, skewer themselves by rambling, recapping their life story, delving into ancient work history or personal matters.
|
|
|
|
|
|
|
|
|