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 would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

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

3 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

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

0 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---