SQL Server Database Administrator Question:

What is DBCC?

Tweet Share WhatsApp

Answer:

DBCC statements are Database Console Commands and come in four flavors: Maintenance, Informational, Validation, and Miscellaneous. Maintenance commands are those commands that allow the DBA to perform maintenance activities on the database such as shrinking a file. Informational commands provide feedback regarding the database such as providing information about the procedure cache. Validation commands include commands that validate the database such as the ever-popular CHECKDB. Finally, miscellaneous commands are those that obviously don't fit in the other three categories. This includes statements like DBCC HELP, which provides the syntax for a given DBCC command.

Download SQL Server DB Administrator PDF Read All 84 SQL Server DB Administrator Questions
Previous QuestionNext Question
How to create a Scrollable Cursor with the SCROLL Option?Explain Databases and SQL Server Databases Architecture?