Answer / mathavan

Indexes are used for faster access of required data in a
large table.

Answer / rajesh naidu

INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

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

2 Answers   CSC,

---

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---