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
4158 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 view would you use to determine free space in a tablespace?

3 Answers

How to make a replica of existing oracle server to another server?

3 Answers

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

any body know about orawaves do they really provide placements in their unique placement program

1 Answers TCS,

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

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

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 r the types of backup?

5 Answers CSC,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Where would you look for errors from the database engine?

0 Answers IBM,

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

For more DB Administration Interview Questions Click Here