Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

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,

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What are different types of sql commands?

0 Answers  

---

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

3 Answers   HCL, Wipro,

---

How does cross join work?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

What are two parts of package ?

2 Answers   Infosys,

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is a natural join?

0 Answers  

---

there are .......different types of serializability

1 Answers   Wipro,

---