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.

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Name three advisory statistics you can collect.

1 Answers  

---

why we use cursors

1 Answers  

---