1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 5545

What is BCP? When do we use it?

 2 9467

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

 3 7939

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

 2 7397

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

 3 13310

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

 3 15301

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

Descon, Digital Domain,

4 30012

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 16500

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

eFunds,

5 15612

What is a trigger?

 7 7545

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?

Accenture, Merrill Lynch, Wipro,

2 14968

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

 1 5837

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

 2 10154

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

 3 11931

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

 5 38860

Un-Answered Questions { SQL Server }

How many types of triggers are there?

631

Why truncate is ddl?

665

Will count(column) include columns with null values in its count?

721

How can you hide the sql server instances?

596

what is a self join? Explain it with an example? : Sql server database administration

547




Why use “nolock” in sql server?

616

What is report rendering ?

107

Why use cursor in sql server?

609

what authentication modes does sql server support? : Sql server database administration

588

What is the default value of an integer data type in sql server 2005?

627

Explain the microsoft sql server delete command? : SQL Server Architecture

646

How to convert character strings into numeric values?

653

What are the advantages of using third-party tools?

612

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

583

Explain the dbcc pintable command when would you use it?

559

For More Un-Answered { SQL Server } Questions Click Here