SQL Server Interview Questions
Questions Answers Views Company eMail

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 4466

What is BCP? When do we use it?

2 8183

What should we do to copy the tables, schema and views from one SQL Server to another?

3 6232




What are the different types of joins and what does each do?

2 6041

What is a sub-query? When would you use one?

3 11406

What are three SQL keywords used to change or set someone?s permissions?

3 12216

What is referential integrity? What are the advantages of it?

Descon, Digital Domain,

4 25312

What is database normalization?

Digicel,

7 12148




Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

eFunds,

5 12809

What is a trigger?

7 4499

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

Merrill Lynch, Wipro, Accenture,

2 10447

What is an execution plan? When would you use it? How would you view the execution plan?

1 4535

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 8573

What are the different types of replication? How are they used?

3 9758

What is the difference between a local and a global variable?

5 34902


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Why do you want to join software field as you have done your BE in Electronics?

1093


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1228


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

781


query processing

1078


How to restore performance issues and how to check?

918






How to trouble shoot if unable to connect SQL Server

854


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1116


what is checksum in sql server.........???

467


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4881


1 01 101 01010

829


How can we call UDF(User Define Function) using C# code in ASP.net ?

4823


whats the maximum size of view state??

1022


What is the difference between online clustering and Offline clustering?

1287


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

675


How much memory that we are using in Logshipping Concept?

775