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 do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

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

2 Answers   Zenith,

---

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

1 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---