Answer Posted / t.murali krishna

Types of joins:
1. Inner join
equi join
non equi join
selfjoin
2.Outer join
left outer
right outer
full outer(from 9i)
3.Natural join(from 9i)
4.cross join

What are the ansi data types supported in oracle?

944

---

What is logical backup in oracle?

1014

---

What happens to the current transaction if the session is killed?

984

---

Explain the difference between replace() and translate() functions in oracle?

1035

---

Difference between inner join vs where ?

1033

---

How to assign values to data fields in record variables?

1029

---

How to select some columns from a table in oracle?

1083

---

Explain index?

1255

---

Can multiple cursors being opened at the same time?

1056

---

What is connection pool in oracle?

985

---

Explain oracle 12c new features for developers?

1055

---

What is a table index in oracle?

1126

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2552

---

Difference between cartesian join and cross join?

1032

---

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

2265

---