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

What column differentiates the V$ views to the GV$ views and how?

What authentication modes does sql server support? : sql server DBA

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

Why would you call update statistics? : sql server DBA

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

Where would you look for errors from the database engine?

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

what is the use of recording information about current session?

What are the steps you will take to improve performance of a poor performing query?

internal architecture

What is a system database and what is a user database? : sql server DBA

Can we take incremental backups in datapump?

For more DB Administration Interview Questions Click Here