Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the purpose of the partition table?

Question Posted / sirisha


What is the purpose of the partition table?..

Answer / Jitendra Kumar Nayak

A partition table in Oracle Database serves multiple purposes: it breaks down large tables into smaller, more manageable units called partitions, which improves query performance by reducing the amount of data scanned during read operations. Partitioning also allows for easier maintenance, as each partition can be maintained independently.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how many ways to get the current time? : Sql dba

1 Answers  

Why do we use joins in sql?

1 Answers  

How can I change database name in sql?

1 Answers  

Why truncate is used in sql?

1 Answers  

Is sql microsoft?

1 Answers  

What is the use of primary key?

1 Answers  

when normalization is required

3 Answers   HCL,

What are tuples in sql?

1 Answers  

Which data type is a composite type?

1 Answers  

How bulk collect improves performance?

1 Answers  

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

Which is better join or subquery?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories