Answer Posted / sourabh sharma

=>INNER JOIN: Return rows when there is at least one match
in both tables
=>LEFT JOIN: Return all rows from the left table, even if
there are no matches in the right table
=>RIGHT JOIN: Return all rows from the right table, even if
there are no matches in the left table
=>FULL JOIN: Return rows when there is a match in one of the
tables

What are the oracle built-in data types?

1003

---

What is the usage of control file in oracle?

1024

---

How oracle handles dead locks?

1017

---

Why is oracle used?

878

---

Does facebook use oracle?

976

---

Difference between hot backup vs. Cold backup?

941

---

Explain oracle’s server parameter file.

946

---

What is a relational database management system?

1061

---

How many types of segments in Oracle?

1011

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2198

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

---

Is truncate autocommit in oracle?

1016

---

How to put more than 1000 values into an oracle in clause?

969

---

What is program global area (pga) in oracle?

951

---

Explain the use of owner option in exp command.

989

---