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 is a full join sql?

0 Answers  

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

how would concatenate strings in mysql? : Sql dba

0 Answers  

---

Is a secondary key the same as a foreign key?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

What is sql catalog?

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

What is data definition language?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

what is row? : Sql dba

0 Answers  

---

Which operator is used in query for pattern matching?

0 Answers  

---