Morgan Stanley Interview Question for Software Engineer / Developers

Comment hidden because of low score. Click to expand.
of 1 vote

1. Clustred vs Non-Clustred
A clustered index forces the data to be stored in the index column sequence. Clustered index is helpful to search range of data values.
Eg: Assume there is an Employee(EmpId, EmpName, Sal, Dept) with clustered index on EmpId column
SELECT Empname
FROM Employee
WHERE EmpId between 8 AND 16.
As the employee records are stored in the sequence of EmpId, we can easily locate EmpIds 9 to 16 once we find the location of record for EmpID 8.

A good example of clustered index is: Dictionary where each page header contains the starting letters of words that are present in that page. If we go to a page, we can easily find all the words adjacent to a particular word.
There can be only one clustered index per table but there can be approximately 249 non-clustred indexes.

Non-Clustred index: A non-clustered index stores location of the data page and an offset to the data record in that page.
A good example is: index on the back of a book

You can refer to the below links for more information
1. sql-server-

- Sadineni.Venkat March 07, 2008 | Flag Reply
Comment hidden because of low score. Click to expand.
of 0 vote

Diff in Having and Where:
Having is used with Group by clause and without group by clause it works similar to where.
Where : It is conditional join between table and it filter the data from tables.

Query Optimization : The best way is to figure out the execution plan and then analysis how the data is fetched. If there are full table scans in large data tables then we need to consider the index. See if table joins are necessary otherwise we need to remove few tables if it is possible.

More details

- java interview Questions February 10, 2013 | Flag Reply

Add a Comment

Writing Code? Surround your code with {{{ and }}} to preserve whitespace.


is a comprehensive book on getting a job at a top tech company, while focuses on dev interviews and does this for PMs.

Learn More


CareerCup's interview videos give you a real-life look at technical interviews. In these unscripted videos, watch how other candidates handle tough questions and how the interviewer thinks about their performance.

Learn More

Resume Review

Most engineers make critical mistakes on their resumes -- we can fix your resume with our custom resume review service. And, we use fellow engineers as our resume reviewers, so you can be sure that we "get" what you're saying.

Learn More

Mock Interviews

Our Mock Interviews will be conducted "in character" just like a real interview, and can focus on whatever topics you want. All our interviewers have worked for Microsoft, Google or Amazon, you know you'll get a true-to-life experience.

Learn More