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 view would you use to look at the size of a data file?

3 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,

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

Explain the concept of the DUAL table.

3 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

What the different types of replication and why are they used? : sql server DBA

0 Answers