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

1 Answers
4293 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer

More DB Administration Interview Questions

What the different components in replication and what is their use? : sql server DBA

0 Answers

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

0 Answers

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers

how can you schedule a job in database?

0 Answers Oracle,

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers iGate,

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers

Where would you look for errors from the database engine?

0 Answers IBM,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

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

Give two examples of referential integrity constraints.

2 Answers

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers

what are the types of connection load-balancing?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here