SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Explain me 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 Administrator Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell me what is the default fill factor value? | Tell me how do you troubleshoot errors in a SQL Server Agent Job? |