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 you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 2418

one table has four field id,name,design,salary. i have to find maximum salary .

6 4244

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 8617

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 2912

How to find the date and time of last updated table?

Teledata,

6 6024

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 20201

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 6620

What value could be assigned to Varchar Type?

3 3539

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 3437

What types of integrity are enforced by a foreign-key constraint

1 2872

What are the main control-of-flow T-SQL constructs?

1 3531

What are the two virtual tables SQL Server maintains for triggers?

3 6174

What does the INSTEAD OF trigger do?

3 5340

What are explicit and implicit transactions?

BirlaSoft,

4 18761

What are the two types of concurrency?

4 5240







Un-Answered Questions { SQL Server }

How does clustered and non clustered index work?

97


What is SQL Azure Firewall?

37


How do I install only the client tools of sql server 2000?

167


Explain the difference between function and stored procedure?

124


What is stored in the mssqlsystemresource database? : sql server database administration

159






What is key set driven?

122


Does a sql server 2005 select statement require a from?

146


How to reaname table name without using sp_Rename in sql server..?

155


When would you use a before or after trigger?

100


what is denormalization and when would you go for it? : Sql server database administration

140


What is the use of sql profiler in sql server 2012?

111


What is the language structure to add a record to a table?

173


Explain Geography datatype in SQL Server

196


What is the use of “join” in sql server?

134


what is raid? : Sql server database administration

126