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 8317

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

1 2709

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

3 3528




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 2410

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

TCS,

3 6096

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

1 2694

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

Wipro,

10 10840

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

HCL,

1 7835




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

HCL,

1 5337

What is blocking and how would you troubleshoot it?

HCL,

3 4395

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

HCL,

3 7400

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

HCL,

1 5855

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

HCL,

2 5888

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

HCL,

3 11128

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

HCL,

2 7147


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

829


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?)

669


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

848


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

573


What are the dis_advantages of stored procedures, triggers, indexes?

903






What is the difference between NOROW and LOCKROW?

1203


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605


role of sql sever 2005 in database rather than any other database

834


How you trouble shoot when any job fails

629


Delete duplicate rows without using rowid.

135


How much memory that we are using in Logshipping Concept?

661


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

315


What is RMS migrations?

902


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

4686


If we delete pack Spec what will be the status of pack Body ?

131