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

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

1 Answers   Cap Gemini, iGate,

---

what is the use of home directory???

1 Answers   HP,

---

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

3 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

How would you force a log switch?

4 Answers  

---