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 is data source document?

122

Can two tables share the same primary key?

106

Can a table have 2 foreign keys?

130

What is meant by datasource?

121

How do I make a resultset scrollable?

111

Is resultset an interface?

118

What is the meaning of resultset type_scroll_insensitive?

113

What is difference between createstatement and preparedstatement?

120

Which is faster statement or preparedstatement?

122

What is the difference between executequery () and executeupdate ()?

114

What is the return type of executeupdate ()?

115

What is create statement?

129

What program is used to store the data source file?

116

What is a data source file?

124

What is difference statement and preparedstatement?

119







Un-Answered Questions { SQL Server }

Define normalisation?

187


How do I find the size of a sql server database?

119


Will sql server 2005 allow you to reduce the size of a column?

172


What are the default system databases in sql server 2000?

165


What stored by the master? : sql server database administration

171






How to call a function from a stored procedure in SQL Server ?

194


What is t-sql script to take database offline – take database online.

147


If the job running very slow what is the action you do

1007


Explain about protocol layer present in SQL server?

175


What is temporary stored procedure?

150


What is the current limitation of the size of SQL Azure DB?

45


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

158


Explain the concepts and capabilities of sql server?

158


How to trouble shoot if unable to connect SQL Server

1088


Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

168