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 updatable resultset?

123

Is port 1433 secure?

114

How do I open port 1433?

122

What is meant by dirty read?

107

How does recursive cte works in sql server?

112

What is correlated subquery in sql server?

120

What do you mean by sql server 2005 express management tools?

167

Can we use max in where clause?

118

What is the use of group by clause?

121

Can we use where and having clause together?

111

Can we use where clause with group by?

130

Can we use where clause in union?

117

Can we use having clause without group by?

109

How do I create a stored procedure in dbml?

119

What is db stored procedure?

115







Un-Answered Questions { SQL Server }

What is data source in connection string?

110


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

137


What's the information that can be stored inside a bit column?

163


What is the syntax for encrypting a column in SQL Server?

171


Where are sql server usernames and passwords stored in the sql server?

167






How to execute the cursor queries with "open" statements?

160


What is proper subset of candidate key?

123


What is a synonym for manipulation?

123


How do you delete a data source?

119


How to delete duplicate records based on single column from a table?

194


What are the filtered indexes?

134


How do I start sql server 2017?

120


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

146


What is the difference between seek predicate and predicate?

152


What is policy based management (pbm)? : sql server database administration

154