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.

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

How do you resize a data file?

2 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

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

0 Answers  

---

When a user process fails, what background process cleans up after it?

1 Answers  

---