adspace


How does a database partition work?

Answer Posted / Chetan Warkari

When a table is partitioned, the data is physically separated into smaller pieces or partitions. Each partition can be stored on a different disk or server, allowing for more efficient querying and management of the data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1910


Is there some bulk load or other way to import a lot of data fast?

933


Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1900


How to export data from database and import into another?

1001


What is a concurrency problem in dbms?

1057


i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1863


What are the two main functions of queries in databases?

1536


Who proposed the relational model?

1037


1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1850


what is the age limit for groups1 examination

2346


What are the advantages of database?

1017


Suppose database is running slow, what will you do?

2598


What versions of clipper does netlib support?

1096


Have you written applications to retrieve stored images in a table?

1089


What are the steps in creating a database?

1016