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 5157

What are the types of model in sql server and explain

TCS,

2 5304

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 12959

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

CTS, TCS,

4 11984

What is the difference between login and a user?

CTS, TCS,

13 27253

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

Value Labs,

4 6827

what is IDE,DMV in sql server?

Value Labs,

1 7714

Wht is Stuff in sql ser

 2 4343

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

 8 9865

what is the diffrence between Snap Shot and Transaction Replication

CSC,

2 11013

What is the default value of CHAR type?

Bosch,

10 18733

How to find the last update record in SQL Server?

 4 15684

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 9617

Can we create a clustered index on composite primary key.

IGT,

3 18190

what is hash table

ILFS, Teledata,

3 19429

Un-Answered Questions { SQL Server }

Explain transaction server consistency?

516

What does executeupdate return?

528

How to find related tables in sql server?

491

What is raid and what are different types of raid levels?

583

what information is maintained within the msdb database? : Sql server administration

504




Explain primary key?

533

How to list all user defined functions in the current database?

509

What is ddl command?

525

What to check if a User database is locked?

581

Is it possible to update the views? If yes, how, if not, why?

533

What is the maximum size per database for sql server express?

546

What does ss stand for sexually?

573

What is the sql profiler?

535

What is perspective, have you ever created perspective? : sql server analysis services, ssas

491

when would you go for denormalization? : Sql server database administration

477

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