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.

How can you gather statistics on a table?

3 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

what is asm?

1 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---

Why would you use sql agent? : sql server DBA

1 Answers  

---

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

1 Answers  

---

Explain the use of table functions.

1 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

1 Answers  

---

what is logical system in sap basis

1 Answers  

---