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?

Accenture,

1105

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?

4686


New concepts of sql server 2005 use in your project.

1189


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 ?

796


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

1263


tell me the disaster recovery plan

1238






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

835


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

663


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

797


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

903


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.

1305


where the connection string store in the database

758


plss anybody specify tha constrian management system in dbms

771


How do you Implement SSIS Packages in your Project?

790


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

793


ow to bring suspect mode datbase online from scratch

644