1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

 2 9940

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

 5 8886

how to dispaly a particular row details from a given table

 2 5301

What is a transaction and what are ACID properties?

 3 6324

Explain different isolation levels?

 4 9509

What's the maximum size of a row?

IBM,

4 10162

Explain Active/Active and Active/Passive cluster configurations?

 1 4144

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 36056

What is lock escalation?

 1 6432

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

 9 16372

Explain the storage models of OLAP?

 1 6685

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

Accenture,

1839

What are constraints? Explain different types of constraints?

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

26 132140

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

 2 9492

what operator performs pattern matching?

 2 10620

Un-Answered Questions { SQL Server }

What is mscorsvw.exe - process - microsoft .net framework ngen?

518

Can you always create a cache of a report?

115

How to get @@error and @@rowcount at the same time?

555

How you can find out if an index is useful to the optimizer?

486

How do I find the size of a sql server database?

476




Can binary strings be used in arithmetical operations?

516

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

493

Can you get second highest salary from the table?

543

What is the difference between ddl and dml?

557

How do you open a cluster administrator?

619

What are scalar functions in sql?

599

How can I check if a view exists in a sql server database?

549

How column data types are determined in a view?

526

What are the different editions available in sql server 2000?

582

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

486

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