Answer / nikhil

Global Index: A global index is a one-to-many relationship,
allowing one index partition to map to many table
partitions. A global index can only be a range partition!

Local Index: A local index is a one-to-one mapping between a
index partition and a table partition. In general, local
indexes allow for a cleaner “divide and conquer” approach
for generating fast SQL execution plans with partition pruning.

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,

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

What is fill factor? : sql server DBA

0 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---