Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?



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

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  


Categories