Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

---

What is the difference between inner join and natural join?

0 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

how will u find statistics of a database objects?

2 Answers   iFlex,

---

What is the use of partition by in sql?

0 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

What are triggers and its uses?

0 Answers  

---

List different type of expressions with the example.

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---