SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is measure group, measure? : sql server analysis services, ssas

1075

What is data mart? : sql server analysis services, ssas

1111

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1058

How will you make an attribute not process? : sql server analysis services, ssas

1160

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1107

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1230

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1321

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1013

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1071

What are translations and its use? : sql server analysis services, ssas

1087

What is a data source or ds? : sql server analysis services, ssas

1053

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1058

What are the types of database schema? : sql server analysis services, ssas

1193

What are types of storage modes? : sql server analysis services, ssas

1090

What is attribute hierarchy? : sql server analysis services, ssas

1069

Un-Answered Questions { SQL Server }

What is stored in the mssqlsystemresource database? : sql server database administration

1081

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1031

How do I connect to sql server database?

1069

How dts is used to extract, transform and consolidate data?

1119

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

960

When we should use and scope of @@identity?

1052

How do you implement session management in SQL Server mode?

1160

What is set nocount on and what is set nocount off?

1000

How to create a scrollable cursor with the scroll option?

1050

What is difference between aggregate and analytic function?

978

What is executereader?

1005

How to create an index on a view?

1143

Is the primary key column of a table an index in ms sql server?

1005

Explain what are the restrictions while creating batches in sql server?

1118

Write a program using SQL queries to find a unique entry in a table.

1055

For More Un-Answered { SQL Server } Questions Click Here