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

1 Answers
4294 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer

More DB Administration Interview Questions

How can we see the database version in os level

6 Answers Oracle,

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

3 Answers

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

0 Answers

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

how can a session indicate its interest in receiving alerts?

0 Answers Oracle,

which background process invoke at the time of upgradation tell me???

0 Answers iGate,

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?

0 Answers

what do you understand by fine-grained auditing?

0 Answers Oracle,

What is the default fill factor value? : sql server DBA

0 Answers

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

what is the difference between catalog & nocatalog?

3 Answers CSC,

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

0 Answers

For more DB Administration Interview Questions Click Here