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

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

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

0 Answers  

Can you redefine a table online?

0 Answers   Oracle,

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

What is fill factor? : sql server DBA

0 Answers  




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

0 Answers  

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

what is the difference between catalog & nocatalog?

3 Answers   CSC,

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

what is asm?

0 Answers   Oracle,

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

For more DB Administration Interview Questions Click Here
Categories