As a part of your job, what are the DBCC command

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC SHRINKFILE etc. But there are a whole load of DBCC commands which are very useful for DBAs.

(Continued on next question...)

Other Job Interview Questions

• What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
• What type of Index will get created after executing the above statement?
• What are constraints? Explain different types of constraints.
• What are the different ways of moving data/databases between servers and databases in SQL Server?
• What is the system function to get the current user's user id?
• Database design - What is normalization? Explain different levels of normalization?
• Database design - What is denormalization and when would you go for it?
• Database design - What is denormalization and when would you go for it?
• Define candidate key, alternate key, composite key.
• What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
• More...