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


SQL Server Interview Questions
Questions Answers Views Company eMail

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

 3 10392

What are the different ways of moving data/databases between servers and databases in SQL Server?

 1 3840

What is database replicaion? What are the different types of replication you can set up in SQL Server?

 3 5558

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

 1 3696

What is the system function to get the current user's user id?

TCS,

3 8488

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

 1 3982

What's the difference between a primary key and a unique key?

Wipro,

10 15952

What are the steps you will take to improve performance of a poor performing query?

HCL,

1 9663

What are the steps you will take, if you are tasked with securing an SQL Server?

HCL,

1 7041

What is blocking and how would you troubleshoot it?

HCL,

3 6942

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

HCL,

3 10047

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

HCL,

1 7795

What are statistics, under what circumstances they go out of date, how do you update them?

HCL,

2 8157

What are the different ways of moving data/databases between servers and databases in SQL Server?

HCL,

3 13895

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

HCL,

2 9453

Un-Answered Questions { SQL Server }

what is a self join? : Sql server database administration

598

List down some advantages of sql stored procedure?

629

What is the sql case statement used for? Explain with an example?

618

What is table constraint?

625

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

815




What sql server means?

648

What is the purpose of sql profiler in sql server? : sql server database administration

709

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2068

What are the recovery models for a database?

691

Explain the properties of subqueries in sql server?

610

what information is maintained within the msdb database? : Sql server administration

573

What it means to be triggered?

574

Can we check locks in database? If so, how can we do this lock check?

596

What is raid and what are different types of raid levels?

674

What is the purpose of linked server configuration in sql server?

621

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