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


SQL Server Interview Questions
Questions Answers Views Company eMail

What are Row versions of DataRow?

 604

What is data block and how to define data block size?

 602

What is cursors?

NA,

636

Can you get second highest salary from the table?

QuestPond,

551

What is the difference between a check constraint and a rule?

 622

What is a Join and explain its types?

 581

What is the user of Primary key?

 579

How does index makes search faster?

QuestPond,

597

How can we delete Duplicate row in table?

Wipro,

632

How would you use user_constraints table in DB?

Wipro,

586

Why do we backup Active Directory ?

 607

What is normalization? Describe its different types.

Wipro,

580

What is the difference between DATETIME2 and DATETIME?

Infosys,

624

What do you mean by the term 'normalization'?

Tech Mahindra,

666

What is the difference between clustered and a non-clustered index?

NA,

591

Un-Answered Questions { SQL Server }

What information is maintained within the msdb database?

537

How many replicas are maintained for each SQL Azure database?

128

Explain the concept of recursive stored procedure.

493

Explain what is log shipping?

576

What is a rollup clause?

543




Does union all remove duplicates?

607

How to run queries with sql server management studio express?

566

Describe in brief sql server monitoring ways.

587

can a table be moved to different filegroup? : Sql server administration

544

What is use of except clause?

625

How to change the data type of an existing column with "alter table" statements in ms sql server?

526

What are the character string functions supported by sql server 2005?

516

How to get the definition of a view out of the sql server?

502

What is the name of the Database which IBM mainframe uses?

536

How to insert stored procedure result into temporary table?

576

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