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


SQL Server Interview Questions
Questions Answers Views Company eMail

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

 2 5555

What are the types of model in sql server and explain

TCS,

2 5675

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 13548

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

CTS, TCS,

4 12624

What is the difference between login and a user?

CTS, TCS,

13 28352

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

Value Labs,

4 7371

what is IDE,DMV in sql server?

Value Labs,

1 8022

Wht is Stuff in sql ser

 2 4708

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

 8 10705

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11419

What is the default value of CHAR type?

Bosch,

10 19803

How to find the last update record in SQL Server?

 4 16179

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 10397

Can we create a clustered index on composite primary key.

IGT,

3 18687

what is hash table

ILFS, Teledata,

3 19831

Un-Answered Questions { SQL Server }

What is correlated subquery in sql server?

724

what stored procedure would you use to view lock information? : Sql server administration

729

How can I tell if sql server is 32 or 64 bit?

693

What is replication and database mirroring?

764

Is the primary key column of a table an index in ms sql server?

688




Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2247

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

716

How many types of stored procedures are there in sql server?

716

How to use “drop” keyword in sql server and give an example?

841

What is attribute relationships, why we need it? : sql server analysis services, ssas

659

What is a Join and explain its types?

765

What is key attribute?

682

What is the sql case statement used for? Explain with an example?

698

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3983

what do you understand by change data capture?

723

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