Answer / guest

Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.


Regards
Abhinav Phadnis

Answer / 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

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

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  

---

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

0 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

What are the recovery models for a database? : sql server DBA

0 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

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

4 Answers  

---

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

0 Answers   Patni,

---