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

what is the main difference between constraints(like primary key etc..)& joins?

2 4378

What are the types of model in sql server and explain

TCS,

2 4419

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 11337

What are the types of backup and tell me the difference between full and differential backup?

CTS, TCS,

4 10566

What is the difference between login and a user?

CTS, TCS,

13 23650

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 5517

what is IDE,DMV in sql server?

Value Labs,

1 6804

Wht is Stuff in sql ser

2 3295

how to get 25th row in any table in sqlserver can u tell me syntax

8 8159

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 10103

What is the default value of CHAR type?

Bosch,

10 15828

How to find the last update record in SQL Server?

4 14321

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

Value Labs,

7 7375

Can we create a clustered index on composite primary key.

IGT,

3 15756

what is hash table

ILFS, Teledata,

3 18375







Un-Answered Questions { SQL Server }

What is the use of “join” in sql server?

165


What is merge statement?

185


What is Transparent Data Encryption?

199


What do you understand by integration services in sql server?

171


How do clustered indexes store data?

165






How to provide column names in insert statements in ms sql server?

163


What are the options which must be set to allow the usage of optimistic models?

164


Do you know sql server 2008 backup compression?

171


Name three of the features managed by the surface area configuration tool? : sql server security

169


How will you find out if there are expensive SQL statements running or not?

190


How is foreign key related to primary key?

137


How to create view in stored procedure sql server?

137


What does it mean to normalize a database and why would you do it?

161


How to list all login names on the ms sql server?

177


What is the difference between for xml raw and for xml auto?

171