SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
What is DBCC?
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 Interview Questions And Answers
PDF
Previous Question | Next Question |
How to create a Scrollable Cursor with the SCROLL Option? | Explain Databases and SQL Server Databases Architecture? |