Answer / ramesh

ALTER INDEX <Index> REBUILD ONLINE;

one Should Configure a script to Rebuild indexes at Regular
intervals for the needy

Answer / ehtesham malik

Alter index index_name REBUILD COPMUTE STATISTICS

Answer / deepak

alter index <indexname> rebulid;

Answer / ravikiran koppisetty

ALTER INDEX INDEXNAME REBUILD

Answer / guest

dbcc dbreindex ('table_name' [, index_name [,
fillfactor ]]) [WITH NO_INFOMSGS]

Answer / kishore

DBCC dbreindex('tabname','indexname','fillfactor')

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1 Answers  

What is fill factor? : sql server DBA

1 Answers  

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

1 Answers   Cap Gemini, iGate,

how can you get actual data change values from previous transactions in oracle?

1 Answers   Oracle,

what is asm?

1 Answers   Oracle,

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

How would you force a log switch?

4 Answers  

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

what is difference between user managed backup and rman backup?

1 Answers   CTS,

Datapump backup steps?

1 Answers