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

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

What is data source object?

What is exporting utility?

What is the ‘fillfactor’?

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

What is model database in sql server?

What is PROJECTION Operation?

Why should we go for stored procedures? Why not direct queries?

What is the difference between clustered and a non-clustered index?

please differentiate between delete and truncate?

How many types of cursors are there in SQL Server?

What is a document index?

For more SQL Server Interview Questions Click Here