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

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

More SQL Server Interview Questions

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

Why do you need a sql server?

What is the synonym of join?

What is subquery in sql?

What is index in an assignment?

Describe triggers features and limitations?

how to find number of columns in a table in sql server 2000 and 2005 also

How can we use ConnectorJ JDBC Driver with MS SQL?

How to use union to merge outputs from two queries together in ms sql server?

How to loop through the result set with @@fetch_status?

How can you stop stored procedures from recompiling?

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

For more SQL Server Interview Questions Click Here