SQL Server Interview Questions (Part 4)

Session on 27-11-13(F_ACC)

· What is ur Project?
· Explain Roles & Responsibilities in ur Project
· What type of Transformations are used and Explain Briefly
· Explain about Performance tuning
· Error and Event Handling
· What type of Sql sever Objects are used in ur Project
· Joins
· Stored Procedures
· Functions and Types
· Views
· Indexes

MSBI Interview Questions (Part 9)

Session on 26-11-13(F_BOA)

· How to u Find Data is there or not in Source
· What are the Containers are used in ur project and why
· Explains Precedence Constraints
· Difference between DTS & SSIS Package
· How to Handle Errors in SSIS
· How to Store Error Logs in SSIS
· What are the Configurations are used in ur Project
· Variables and Explain when u used Variables in ur Project
· In ur Project u used Sequence Container
· I want to Migrate data from Flat File to Sql Server , How the Performance can be improved
· Briefly Explains How many Stages in ur Project
· Script Task and Explain how many ways to ur Script Task in ur Project
· What type of Script used in ur project and Why
· What is Paradox Server and Explains

SQL Server Interview Questions (Part 3)

Session on 26-11-13(F_BOA)

· Difference between Having & Where Clause and both are using in same Select Command
· Difference between Join & Union
· How to Handle Errors in SP and How to Store Errors in Another Table
· How to Get Next Auto generated Value in Sql
· Sub Queries and Explain when u used SubQueries in ur Project
· How to find 2nd Largest Salary of Employee in a Table
· How to find 3rd Largest Salary of Employee in a Table
· In above Two Question without SubQueries u implemented or Not
· Explain Simple use of Substring , Lowercase and Uppercase

· Table1 contains Student Details like Student Number and Name, Table2 contains Student Marks and Grades. U find who had fallen between Minimum and Maximum Respective Grades