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 10993

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

5 10792

how to dispaly a particular row details from a given table

2 6287

What is a transaction and what are ACID properties?

3 7924

Explain different isolation levels?

4 11061

What's the maximum size of a row?

IBM,

4 11938

Explain Active/Active and Active/Passive cluster configurations?

1 5021

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37491

What is lock escalation?

1 7204

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

9 19411

Explain the storage models of OLAP?

1 7452

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

Accenture,

2414

What are constraints? Explain different types of constraints?

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

26 140493

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

2 10735

what operator performs pattern matching?

2 11798

Un-Answered Questions { SQL Server }

What is a partition function in sql server?

1223

What is code near application topology?

283

What is the difference between functions and stored procedures?

1229

Mention the different types of triggers?

1215

Tell me about joins in database system and explain each in detail.

1112

How to truncate the log in sql server 2012? : sql server database administration

1354

How to replace null values in expressions using isnull()?

1154

what are different types of backups available in sql server? : Sql server database administration

987

What is the difference between a primary key and a unique key? Are they the same?

1128

How do I perform an unattended install of sql server 2000?

1146

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1019

What are cursors and when they are useful?

1154

Explain the difference between cross join and full outer join?

1034

What is sql server locking?

1036

Explain trigger classes i.e. Instead of and after trigger?

921

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