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

Explain what are magic tables in sql server?

988

Tell me what are cursors and when they are useful?

953

Do you know what is a linked server in sql server?

1021

Do you know what is difference between stored procedure and user defined function?

1089

Tell me when is the update_statistics command used?

1104

Explain the xml support sql server extends?

1035

Explain the rules for designing files and file groups in sql server?

984

Do you know what is rank function?

1071

Tell me what is normalization? Explain different forms of normalization?

1027

Do you know what are acid properties?

1073

Do you know what are the steps to process a single select statement?

966

Explain what is public role in sql server?

1119

Do you know how to send email from database?

994

Explain what is analysis service repository?

984

What is the order in which the sql query is executed?

938

Un-Answered Questions { SQL Server }

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

921

Does sql server use t sql?

1015

What the different components of Replication and what is their use?

1064

Explain sql server authentication modes?

1125

Why are you getting errors when creating a new odbc dsn?

1213

Explain syntax for viewing, dropping and disabling triggers?

948

What is used to replicate sessions between instances in coldfusion clusters?

1067

What is thr feature of change data capture?

974

What is sqlservr.exe - process - sql server (sqlex?press)?

1104

What is the difference between value type and reference type?

917

What does asynchronous call backs means?

1153

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

913

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1383

Can a cursor be updated? If yes, how you can protect which columns are updated?

1102

What is query processing?

932

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