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

How to configure and test odbc dsn settings?

What are the rules to use the rowguidcol property to define a globally unique identifier column?

How to delete an existing database user?

What are the various editions of sql server 2017 that are available in the market?

Explain what you mean by 3 tier architecture.

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

What is the difference between lock, block and deadlock? : sql server database administration

Where are full-text indexes stored?

Does full backup break log chain?

What are the different types of replication are there in sql server 2000?

What is normalization according to you and explain its different levels?

Explain cross join or cartesian product in sql?

For more SQL Server Interview Questions Click Here