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 10887

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

5 10597

how to dispaly a particular row details from a given table

2 6179

What is a transaction and what are ACID properties?

3 7731

Explain different isolation levels?

4 10890

What's the maximum size of a row?

IBM,

4 11762

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 7128

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

9 19079

Explain the storage models of OLAP?

1 7376

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 139540

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

2 10607

what operator performs pattern matching?

2 11701

Un-Answered Questions { SQL Server }

What is the difference between createstatement and preparedstatement?

940

What is a hint?

993

Can foreign key be deleted?

923

How do you clear a log file?

1047

What is the difference between clustered index and primary key?

921

What is the difference between Clustered and Non-Clustered Index?

1059

What is sub-query in sql server? Explain its properties.

1092

Describe triggers features and limitations?

989

Explain following error properties?

1017

How to create a simple table to test triggers in ms sql server?

975

What to check if a User database is locked?

1069

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

964

What is Sqlpaging in SqlServer 2005 ?

1065

What are the triggers in sql?

1105

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1037

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