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 5453

What is BCP? When do we use it?

 2 9324

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

 3 7726

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

 2 7281

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

 3 13125

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

 3 15106

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

Descon, Digital Domain,

4 29721

What is database normalization?

Deloitte, Digicel, JPMorgan Chase, Verifone,

7 16141

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

eFunds,

5 15322

What is a trigger?

 7 7264

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 14676

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

 1 5723

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

 2 9995

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

 3 11750

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

 5 38580

Un-Answered Questions { SQL Server }

How to get nth highest salary from employee table.

609

Explain different forms of normalization?

519

Explain table valued parameters in sql server? Why tvp used?

543

How to choose all records from the table?

642

Which is the main third-party tool used in sql server?

470




What is the process of normalization?

545

Can you use order by when defining a view?

565

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

651

How to send email from database?

568

How to make remote connection in database?

586

Explain temporary table vs table variable by using cursor alternative?

514

Explain about system database?

570

Detail about query optimizer?

601

How to list all columns in a table using odbc_columns()?

527

What do you think of this implementation? Can this be implemented better?

527

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