Thursday 17 October 2013

MSBI Interview Questions (Part 8)

Session on 15-10-13(FM)

· Second Max of Emp without using CTE (5th after 7th)
· Please write query for Retrieve Except colour Blue Records only

Product Id
Name
Colour
1
Soap
Black
2
Vehicle
Blue
3
XXXX
Red
4
ZZZZ
Orange
5
AAAA
Metal
6
BBBB
Blue

· What is Difference between Delete and Truncate
· Performance Tuning in SSIS
· Explain Flow draw of ForEachLoop Container with Example
· Difference between Function and SP
· Cluster and Non Cluster Indexes
· Write a Query for Below I/P and O/P
  I/P

Year
Month
Sales
2012
Jan
10000
2012
Feb
20000
O/P

Year
Jan
Feb
2012
10000
20000

· What is O/P

Select 1
Union all
Select 1

· How to Create Cube (Clearly Explain)

No comments:

Post a Comment