SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 8267

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

5 6245

how to dispaly a particular row details from a given table

2 3701

What is a transaction and what are ACID properties?

3 4679

Explain different isolation levels?

4 7369

What's the maximum size of a row?

4 7497

Explain Active/Active and Active/Passive cluster configurations?

1 2968

Explain the architecture of SQL Server?

HP, Oracle, ABC,

2 33163

What is lock escalation?

1 5262

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

9 12599

Explain the storage models of OLAP?

1 5294

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?

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

26 116197

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

2 7702

what operator performs pattern matching?

2 8432

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


New concepts of sql server 2005 use in your project.


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


what exactly sql injuction.how to overcome.....


tell me the disaster recovery plan


what is package and it uses and how can u call a package


If the job running very slow what is the action you do


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


What are the dis_advantages of stored procedures, triggers, indexes?


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


where the connection string store in the database


plss anybody specify tha constrian management system in dbms


How do you Implement SSIS Packages in your Project?


on line cluster can we make if yes tell me the procedure


ow to bring suspect mode datbase online from scratch