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 10866

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

5 10576

how to dispaly a particular row details from a given table

2 6166

What is a transaction and what are ACID properties?

3 7713

Explain different isolation levels?

4 10865

What's the maximum size of a row?

IBM,

4 11738

Explain Active/Active and Active/Passive cluster configurations?

1 4914

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37325

What is lock escalation?

1 7122

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

9 19052

Explain the storage models of OLAP?

1 7367

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

Accenture,

2358

What are constraints? Explain different types of constraints?

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

26 139413

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

2 10588

what operator performs pattern matching?

2 11690

Un-Answered Questions { SQL Server }

What is global temp table?

989

How can I add Reporting Services reports to my application?

129

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1042

What is the difference between resultset and resultsetmetadata?

949

What command is used to create a database in the sql server and how?

1169

How to execute a sql statement using odbc_exec()?

1130

Explain what are page splits? : SQL Server Architecture

1054

How to convert numeric expression data types using the cast() function?

1057

Why I can not enter 0.001 second in date and time literals in ms sql server?

1052

Does index speed up select statements?

1010

Explain what is row_number function?

1014

Where sql server usernames and passwords are stored in a sql server?

981

Explain the etl (extraction, transformation, and loading)?

989

Define Wed Edition in SQL Azure?

100

What is the beast way to write CTE in SQL Server ?

1039

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