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 are the advantages of paper records?

121

What is the difference between sdf and mdf?

128

What is acid db?

115

How do I find my localdb version?

111

What are the 7 disadvantages to a manual system?

124

What is a dbms wizard?

149

What is advantage data architect?

129

What is field in algebra?

119

What is a field name?

112

Where is localdb stored?

118

How do I know if localdb is running?

118

What does normalization do to data?

125

What are the five characteristics of good data?

119

What is data file in computer?

121

Why is normalisation important?

122







Un-Answered Questions { SQL Server }

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

173


What are page splits? : SQL Server Architecture

158


Explain the truncate command?

136


what are the types of indexes? : Sql server database administration

164


What are the two authentication modes in sql server?

178






How to execute a sql statement using odbc_exec()?

157


Explain syntax for dropping triggers?

129


What is Federation and Federation Member?

26


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

215


How do you migrate data from mssql server to azure?

82


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

142


What is 'write-ahead log' in sql server 2000 ?

204


How many types of attribute relationships are there? : sql server analysis services, ssas

168


What are the steps you should follow to start sql server in single-user mode?

150


Write the queries for commands like Create Table, Delete table, Drop Table etc.

186