SQL Administrator Question:

Download Job Interview Questions and Answers PDF

Explain me what is DBCC?

SQL Administrator Interview Question
SQL Administrator Interview Question

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 Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is the default fill factor value?Tell me how do you troubleshoot errors in a SQL Server Agent Job?