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

If there is failure during updation of certain rows, what will be the state?

2 10769

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 10415

how to dispaly a particular row details from a given table

2 6099

What is a transaction and what are ACID properties?

3 7565

Explain different isolation levels?

4 10753

What's the maximum size of a row?

IBM,

4 11601

Explain Active/Active and Active/Passive cluster configurations?

1 4836

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37232

What is lock escalation?

1 7048

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 18788

Explain the storage models of OLAP?

1 7289

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

Accenture,

2331

What are constraints? Explain different types of constraints?

Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

26 138656

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 10498

what operator performs pattern matching?

2 11583

Un-Answered Questions { SQL Server }

How can i Relate Tables in SSIS

1048

Why olap is used?

928

What is indexing a document?

978

How to Sync Two SQL Azure Databases?

119

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1074

Define union, union all, minus, intersect?

937

what are the different types of SSRS reports?

147

Can you explain the disadvantages/limitation of the cursor?

923

What is tcl in sql server?

1085

Are null values the same as that of zero or a blank space?

998

What is difference between cte and view?

864

What is the difference between cartesian product and cross join?

820

Explain what is the purpose of sql profiler in sql server?

1024

What methods do you follow to protect from sql injection attack?

979

What are commonly used odbc functions in php?

983

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