I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What does count (*) do in sql?

0 Answers  

---

What's the procedure?

0 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

What is the difference between a procedure and a function?

0 Answers  

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---

what is the use of friend function? : Sql dba

0 Answers  

---

Can a table contain multiple primary key’s?

0 Answers  

---

What is pl sql variable?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---