DBCC Command :
DBCC stands for Database consistency checker. DBCC commands act as database console commands which means that they are used to check the consistency of SQL server database.
DBCC Command Use :
Database Consistency Checker Commands give details in form of statistics
about the SQL Server. They can be used for Maintenance of database,
index, or filegroup. DBCC Commands can be used to perform validation
operations on a database, table, index, catalog, filegroup, or
allocation of database pages.
They can perform miscellaneous tasks such as enabling trace flags or removing a DLL from memory. DBCC INDEXDEFRAG, DBCC ERRORLOG, DBCC CACHESTATS are one of the few DBCC commands.
Ex : to checks the data page integrity of the author table
DBCC CHECKTABLE ('sample')