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 are the types of processing and explain each? : sql server analysis services, ssas

1205

What is attribute? : sql server analysis services, ssas

1069

Explain the flow of creating a cube? : sql server analysis services, ssas

1100

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1010

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119

What is a cube? : sql server analysis services, ssas

1051

What is named calculation? : sql server analysis services, ssas

1023

What is molap and its advantage? : sql server analysis services, ssas

1036

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1023

How many types of attribute relationships are there? : sql server analysis services, ssas

1133

What is deploy, process and build? : sql server analysis services, ssas

1154

How will you hide an attribute? : sql server analysis services, ssas

1010

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

What is cube dimension? : sql server analysis services, ssas

1048

What is named query? : sql server analysis services, ssas

1003

Un-Answered Questions { SQL Server }

Explain different forms of normalization?

1001

What is the full form of dql?

1024

New concepts of sql server 2005 use in your project.

2401

What is your recommendation for a query running very slow? : sql server database administration

1111

What is autocommit mode in sql server?

1265

What is the most common type of join?

1038

What is 3nf normalization form?

1168

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1220

What is a transaction and why is it important?

1162

Can sub report data source be different from that of the parent report?

149

What are the steps you should follow to start sql server in single-user mode?

951

Is it safe to delete log files?

971

Explain the creation and execution of a user-defined function in the sql server?

1111

What do you mean by the term 'normalization'?

1282

What is the difference between a local and a global temporary table?

1174

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