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 varchar example?

0 Answers  

---

How to use boolean type in select statement?

0 Answers  

---

How to revise and re-run the last sql command?

0 Answers  

---

What is trigger point?

0 Answers  

---

Can you have more than one key in a database?

0 Answers  

---

what is data manipulation language? : Sql dba

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

Explain the difference in execution of triggers and stored procedures?

0 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

What is difference between mysql and postgresql?

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---