Does hive support indexing?

0 Answers  

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

What is Schema? and why we use schemas?

4 Answers  

---

What is self join in sql server joins?

0 Answers  

---

---

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

What do you understand by a stored procedure?

0 Answers  

---

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

Explain the stored procedure?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---