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

Give the two types of tables involved in producing a star schema and the type of data theyhold.

what is the use of home directory???

what is the last version,the release date of that version and fix pack of ibm db2 udb?

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

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

What is blocking and how would you troubleshoot it?

Explain an ORA-01555

What command would you use to encrypt a PL/SQL application?

What types of replication are supported in sql server? : sql server DBA

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

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

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

For more DB Administration Interview Questions Click Here