Interested to Buy Any Domain ? << Click Here >> for more details...
Explain what partitioning is and what its benefit is.
- 2 Answers
- 7523 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how can you implement fine-grained auditing?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what do you understand by fine-grained auditing?
What is the default fill factor value? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is a system database and what is a user database? : sql server DBA
Why would you use sql agent? : sql server DBA
