Answer Posted / rahul baheti

Joins means we can join two or more then two table in
single query. and joins is combinatoin of two or more table.
there are Four type of join
1 Equi joins
2 Non Equi joins
3 Outer joins
4 Self joins

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1925

---

What is object data modeling?

956

---

How to list all tables in your schema?

1052

---

What is a parameter file in oracle?

1127

---

What are the different windows events activated at runtime ?

2898

---

How to convert raw data type into text in oracle? Explain

991

---

How to define a sub function?

1127

---

Explain view?

1028

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1938

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2267

---

What is blob data type in oracle?

1117

---

What are oracle functions?

1028

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2100

---

Difference between the “verify” and “feedback” command?

1360

---