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 would you use to improve performance on an insert statement that places millions of rows into that table?

what do you understand by flashback feature of oracle?

What is a correlated sub-query? : sql server DBA

What type of index should you use on a fact table?

What are the different ways of moving data or databases between servers and databases in SQL Server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

what is ora 600?

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

what is the use of home directory???

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

what is the role of dip user in our database?

what do you understand by fine-grained auditing?

For more DB Administration Interview Questions Click Here