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.

Does truncate require commit?

0 Answers  

---

what is table? : Sql dba

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

explain what is mysql? : Sql dba

0 Answers  

---

What are the advantages of the packages

6 Answers   Oracle,

---

Can a trigger call a stored procedure?

0 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

What is triggering circuit?

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

What is null in pl/sql?

0 Answers  

---

What is procedure in pl sql?

0 Answers  

---