Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 9008

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

5 7201

how to dispaly a particular row details from a given table

2 4365

What is a transaction and what are ACID properties?

3 5272

Explain different isolation levels?

4 8264

What's the maximum size of a row?


4 8444

Explain Active/Active and Active/Passive cluster configurations?

1 3447

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 34789

What is lock escalation?

1 5750

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

9 14070

Explain the storage models of OLAP?

1 5979

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



What are constraints? Explain different types of constraints?

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

26 123667

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

2 8517

what operator performs pattern matching?

2 9471

Un-Answered Questions { SQL Server }

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration


How can change procedure in sql server?


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


How to invoke a trigger on demand?


Explain about builtinadministrator?


What is the importance of a recovery model?


What is the purpose of sql profiler in sql server? : sql server database administration


Do you know spatial data types - geometry and geography in sql server 2008?


Explain optimistic and pessimistic concurrency?


What is the need for indexing?


What is exporting and importing utility?


What is it unwise to create wide clustered index keys?


Explain filtered indexes benefits?


what type of index will get created after executing the above statement? : Sql server database administration


What is best institute to Learn DotNET And SQL in chennai?