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

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 32433

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

1 3115

Define Check points and End Points?

1 2265

How to know whether our backup is succesfully taken?

1 2010

What is a Lock and let me know Different types of locks?

2 3219

What is a Trace frag?Where can we use this?

1 2271

How many .ndf files can we create in Sql server 2005?

Wipro,

2 3888

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 3182

What is Schema? and why we use schemas?

4 5969

How do you Implement SSIS Packages in your Project?

1113

Explain Different types of Projects?

1 2465

What is data modeling and Reterminal integrity?

965

How to restore performance issues and how to check?

1124

Tell about MOM Tool(Microsoft Operator Manager)?

984

Please tell me some knowledge about Clustering and how to add clustering?

1 2453







Un-Answered Questions { SQL Server }

Explain about system stored procedure?

131


How to delete multiple rows with one delete statement in ms sql server?

140


What are synonyms?

153


Which are the third-party tools used in sql server and why would you use them?

107


What are the tools available in market as an alternative to sql server reporting services?

22






Explain the purpose of indexes?

118


What is a view and what are its advantages?

153


How would you choose between a clustered and a non-clustered index?

154


Where the sql logs gets stored?

144


Difference between DELETE and TRUNCATE?

167


Explain alternate key, candidate key and composite key in sql server?

119


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

151


Tell me what are cursors and when they are useful?

131


What happens if null values are involved in bitwise operations?

139


Tell me about joins in database system and explain each in detail.

149