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 scope of pl sql developer in future?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

which types of join is used in sql widely? : Sql dba

0 Answers  

---

What is row_number () in sql?

0 Answers  

---

Explain the components of sql?

0 Answers  

---

---

what are the advantages of package?

7 Answers   iFlex,

---

What is consistency?

0 Answers  

---

write a query to find 4th max salary

7 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

---