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 sql indexes?

0 Answers  

---

What is sql key?

0 Answers  

---

What happens when a trigger is associated to a view?

0 Answers  

---

What is a dynamic query?

0 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

How to run sql functions in pl/sql?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

What is coalesce sql?

0 Answers  

---

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What are sql triggers used for?

0 Answers  

---