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.

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

What is the difference between Datapump & export/import?

2 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

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

1 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

what is asm?

0 Answers   Oracle,

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---