Follow Our FB Page << CircleMedia.in >> 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?

IBM,

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?

Accenture,

1437

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

141


How can change procedure in sql server?

106


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

1410


How to invoke a trigger on demand?

121


Explain about builtinadministrator?

132






What is the importance of a recovery model?

163


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

173


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

143


Explain optimistic and pessimistic concurrency?

127


What is the need for indexing?

104


What is exporting and importing utility?

141


What is it unwise to create wide clustered index keys?

105


Explain filtered indexes benefits?

157


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

136


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

1254