Answer Posted / samir kumar sahoo

Generally there are five types of joins in oracle:

Self Join
Equi Join
Cartesian Join
Outer Join(Left outer join,Right outer join)
Non_Equi JOin

How do I call oracle stored procedures that take no parameters?

1116

---

Describe the types of sub query?

999

---

What are the common oracle dba tasks?

1150

---

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

1036

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2355

---

How to calculate date and time differences in oracle?

1042

---

How data locks are respected in oracle?

1071

---

What is oracle in java?

972

---

How to create a new table in oracle?

1158

---

Is primary key indexed by default in oracle?

987

---

Explain the use of constraints option in exp command.

1048

---

How to rollback the current transaction in oracle?

1055

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1973

---

How to create a table index in oracle?

1134

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1989

---