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 10889

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

5 10599

how to dispaly a particular row details from a given table

2 6180

What is a transaction and what are ACID properties?

3 7734

Explain different isolation levels?

4 10895

What's the maximum size of a row?

IBM,

4 11764

Explain Active/Active and Active/Passive cluster configurations?

1 4924

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37343

What is lock escalation?

1 7129

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

9 19083

Explain the storage models of OLAP?

1 7378

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

Accenture,

2362

What are constraints? Explain different types of constraints?

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

26 139548

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

2 10610

what operator performs pattern matching?

2 11701

Un-Answered Questions { SQL Server }

What happens when converting big values to integers?

999

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1203

What are character string data types in ms sql server?

1251

What is measure group, measure? : sql server analysis services, ssas

1013

What is implicit mode in sql server?

1105

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

How to choose all records from the table?

1070

How to make remote connection in database?

1005

Do you know what is fill factor and pad index?

1004

How many types of objects are there?

1008

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1025

How do I find the query plan in sql server?

958

What is the difference between drop table and truncate table?

924

What is full outer join in sql server joins?

1068

What do you think of this implementation? Can this be implemented better?

945

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