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

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

Question Posted / guest

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

DBCC commands are most useful for performance and troubleshooting

PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....

Is This Answer Correct ?

0 Yes

0 No

More DB Administration Interview Questions

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

Explain CREATE DATABASE syntax?

Explain the use of setting GLOBAL_NAMES equal to TRUE.

What is transparent data encryption? : sql server DBA

how can you process messages in order asynchronously?

Explain how you would restore a database using RMAN to Point in Time?

What is the dataguard background process??

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

what r the types of backup?

Explain the use of table functions.

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

What are the operating modes in which database mirroring runs? : sql server DBA

For more DB Administration Interview Questions Click Here