Answer / s

A.HASH partitioning is useful on columns which are unique
in nature where range or list partitioning cannot be done.
All the hash partitions hold an equal number of rows
thereby improving the performance and response time of the
query if the table is queried.

List partition is used on a table if you can divide table
based on column value. Something like region wise
partioning if the table contains a column like region.The
advantage of list partitioning is that you can group and
organize unordered and unrelated sets of data in a natural
way.

What are the data types allowed in a table?

3 Answers  

---

How do you modify a table in sql?

0 Answers  

---

what is a field in a database ? : Sql dba

0 Answers  

---

what is an alias command? : Sql dba

0 Answers  

---

What is the use of stored procedures?

0 Answers  

---

---

What is sql architecture?

0 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

How many columns should be in an index?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

Which table is left in left join?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---