SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What are Row versions of DataRow?

1028

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

1026

What is cursors?

NA,

1186

Can you get second highest salary from the table?

QuestPond,

965

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

1249

What is a Join and explain its types?

1103

What is the user of Primary key?

985

How does index makes search faster?

QuestPond,

979

How can we delete Duplicate row in table?

Wipro,

1066

How would you use user_constraints table in DB?

Wipro,

1008

Why do we backup Active Directory ?

1042

What is normalization? Describe its different types.

Wipro,

1103

What is the difference between DATETIME2 and DATETIME?

Infosys,

1079

What do you mean by the term 'normalization'?

Tech Mahindra,

1209

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

NA,

1028

Un-Answered Questions { SQL Server }

What is bcp? When does it use?

943

What is it unwise to create wide clustered index keys?

1007

What are the difficulties faced in cube development? : sql server analysis services, ssas

1041

What are different types of database indexes?

1099

what's sql server? : Sql server database administration

996

What are the steps you can take to avoid “deadlocks”?

978

Difference between LEN() and DATALENGTH() in sql server ?

1104

Define synonym?

1173

Define self join?

1028

What are the types of dml?

978

What is the full form of dql?

982

How to automatically create a log when an exception is being received into SQL Server?

1287

Explain difference between control flow and data flow?

965

Is truncate autocommit?

938

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2929

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