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

Is Sql non procedural query language?

Verifone,

199

Write a SQL command to insert and update only a particular field?

ADITI,

194

How efficient you are in oracle and SQL server?

CGI,

223

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

187

What do you understand by SQL*Net?

Tech Mahindra,

188

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

184

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

184

When to use Inner join & when to use subquery?

IBM,

177

how many type of indexing in database?

IBM,

191

Difference between rowid and rownum in SQL?

Virtusa,

179

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

188

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

185

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

189

What Is Rdbms?

Accenture,

184

How can you tell if a database object is invalid?

MCN Solutions,

193







Un-Answered Questions { SQL Server }

Explain activity monitors

169


What is difference between line feed ( ) and carriage return ( )?

151


What is 1nf 2nf?

120


How does the report manager work in SSRS?

35


Why use sub query in sql server and list out types of sub queries?

164






Explain Geography datatype in SQL Server

221


What is a cursor, index in sql?

161


What is the difference between index seek vs. Index scan?

162


Explain the microsoft sql server delete command?

157


Explain what is sql server english query?

156


What is the main purpose of having conversation group?

155


Do you think BCNF is better than 2NF & 3NF? Why?

217


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1106


How to drop existing indexes in ms sql server?

161


How many levels of sp nesting is possible?

155