Answer Posted / ramesh

And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability

2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations

what is grd?

1047

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1917

---

what is the diffrence between core dba and apps dba?

2508

---

what is a crs resource?

1110

---

how can you process messages in order asynchronously?

928

---

What is replication? : sql server DBA

1099

---

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

1048

---

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

2186

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1914

---

How do you trace the traffic hitting a sql server? : sql server DBA

1463

---

What are the steps you will take to improve performance of a poor performing query?

2789

---

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

968

---

Explain materialized views and how they are used.

2379

---

What purpose does the model database server? : sql server DBA

1095

---

What is dbcc? : sql server DBA

1214

---