Answer / rrr2009cse@gmail.com

while moving tables to the other tablespace the indexes has been unused due to movement of segments(tables). to reuse previous index on a table has to be rebuild
alter index indxname tablespace

Answer / mohapatra.gouranga@gmail.com

> Index rebuild nothing of Drop and re-create of Index.
> Is usefull to move index from one tablespace to other.
> Do not do if not necessary.
> In case of migration, do only validate structure for the
indexex.

how can you initialize log miner?

0 Answers   Oracle,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

---

What is checkpoint?

3 Answers   Accenture,

---

Oracle 11g new features?

2 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

what is ora 600?

1 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

Explain the concept of the DUAL table.

3 Answers  

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---