Answer / orawhiz

Hash clusters are better choice when a table is often
queried with equality queries. For such queries the
specified cluster key value is hashed. The resulting hash
key value points directly to the area on disk that stores
the specified rows

is database gud carrier option??

1 Answers  

---

Can you drop an index associated with a unique or primary key constraint?

0 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

---

what is the difference between sql& oracle?

11 Answers   Oracle,

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

how to find full database size

1 Answers   BirlaSoft, Consultancy,

---

What is raw datatype?

0 Answers  

---

How many memory layers are in the shared pool?

1 Answers  

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

Explain the use of rows option in exp command.

0 Answers  

---

how to get the second max val for every group in a table

6 Answers   Verizon,

---