What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

How is indexing done in search engines?

0 Answers  

---

What is pl sql architecture?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

What is cascade in sql?

0 Answers  

---

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

Can we have two clustered index on a table?

0 Answers  

---

Can %notfound return null after a fetch?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---