1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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?..

Answer / irimi

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

what is incremental checkpoint?

1 Answers   CTS,

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1 Answers  

what are the performance views in an oracle rac environment?

1 Answers   Oracle,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

Which autogrowth database setting is good? : sql server DBA

1 Answers  

what do you understand by flashback feature of oracle?

1 Answers   Oracle,

what r the types of backup?

5 Answers   CSC,

how can you find out if a table can be redefined?

1 Answers   Oracle,

What command would you use to create a backup control file?

2 Answers  

Where would you look for errors from the database engine?

1 Answers   IBM,

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

0 Answers  

Name two files used for network connection to a database.

5 Answers  

For more DB Administration Interview Questions Click Here
Categories