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

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

Question Posted / swapna


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

Answer / swapna

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is onf in normalization form?

0 Answers  

How you trouble shoot when any job fails

0 Answers  

What is difference between join and natural join?

0 Answers  

How many clustered indexes there can be on table ?

0 Answers  

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,




select empid empname from employee What is the result for the about query?

4 Answers  

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

What is a covered index?

0 Answers  

What is self contained scalar sub query?

0 Answers  

How to concatenate two character strings together?

0 Answers  

What is the use of @@spid?

0 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

For more SQL Server Interview Questions Click Here
Categories