Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 7899

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

1870

ow to bring suspect mode datbase online from scratch

1243

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1370

wat new abt truncate in sql server

HCL, HP,

2 5093

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1324

on line cluster can we make if yes tell me the procedure

Microsoft,

1372

which backup strategy you are following at ur company

1589

your distribution database is full what will u do

1531

Differences between logshipping and mirroring

Microsoft, Syntel,

1 4207

tell me the disaster recovery plan

Microsoft,

1876

application server is slow what may be the problem

Microsoft,

1626

Define the term DML, DDL and DTL?

1 28184

Creating Tables Using SELECT

1 2408

How can I create a table from another table without copying any values from the old table?

3 4260


Un-Answered Questions { SQL Server }

Can we update data in a view?

450


How many types of schemas are there?

388


How can we delete Duplicate row in table?

480


What are the advantages of paper records?

394


How do I manually uninstall an instance of sql server 2016?

370






What is indexing a document?

375


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

370


How can we solve concurrency problems?

406


What is exclusive locks?

382


What is an example of a foreign key?

356


Explain isolation levels that sql server supports?

433


do views contain data ?

449


Explain transaction server consistency?

369


What are the advantages of policy management?

418


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

441