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
4247 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

How do you resize a data file?

2 Answers

What is the difference between Datapump & export/import?

2 Answers

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers

Name three advisory statistics you can collect.

1 Answers

What are the different authentication modes in sql server and how can you change authentication mode? : 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

When a user process fails, what background process cleans up after it?

1 Answers

how can you record information about current session?

0 Answers Oracle,

what are the types of connection load-balancing?

0 Answers Oracle,

what is the diffrence between core dba and apps dba?

0 Answers Cap Gemini,

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here