Answer Posted / m.sivakumar

joins is a that combines the rows from two or more tables

joins are 5 types
1.cross join
2.equi join or inner join
3.outer join
4.self join
5.non_equi join

How to synchronize 2 schema's objects?

2114

---

How will you write a query to get a 5th rank student from a table student_report?

1812

---

Can you create a synonym without having a table?

975

---

What is recovery manager(rman) backup in Oracle?

1123

---

What is the data pump import utility?

966

---

What is the difference between Delete, Truncate and Drop in Oracle?

1062

---

What do you mean by a tablespace?

980

---

How to create tables for odbc connection testing?

1001

---

What are the execution control statements?

1012

---

Can we use bind variables in oracle stored procedure?

896

---

What is connection pool in oracle?

926

---

How to shutdown your 10g xe server?

1079

---

What is not equal to in oracle?

947

---

What is the difference between online and offline backups?

969

---

What is oracle server autotrace in oracle?

1086

---