Answer Posted / jeetesh dubey

schema is a collection of object,class and attribute.

How oracle handles dead locks?

602

---

How to export several tables together?

568

---

How to join two tables in a single query using oracle?

566

---

Explain the use of record option in exp command.

535

---

What is a system tablespace?

600

---

---

what is the difference between restoring and recovering?

558

---

What are the original export and import utilities?

571

---

What are internal user account in oracle?

571

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

568

---

When do you get a .pll extension in oracle?

679

---

What is difference between truncate and delete?

561

---

Query to retrieve record for a many to many relationship ?

2079

---

How to convert times to characters in oracle?

607

---

Why oracle is used?

580

---

Explain a private synonyms?

634

---