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 operating systems are supported by oracle database 10g xe?

1034

---

What do you understand by a database object? Can you list a few of them?

1018

---

How to define an oracle sub procedure?

1146

---

Can you assign multiple query result rows to a variable?

988

---

Explain oracle’s server parameter file.

995

---

What privilege is needed for a user to create tables in oracle?

953

---

How do you bind variables in oracle?

980

---

What is dynamic proxy?

1008

---

What is transport network substrate (tns) in oracle?

1047

---

How to define a procedure inside another procedure?

1024

---

How to call a stored function in oracle?

1018

---

What is hash cluster in oracle?

1174

---

Explain the use of tables option in exp command.

1117

---

Please explain joins in oracle?

1062

---

How to save query output to a local file?

1027

---