Answer Posted / jimmy

schema is structures created in text in database language .

How would you go about verifying the network name that the local_listener is currently using?

1607

---

What is catalog in Oracle?

649

---

What privilege is needed for a user to query tables in another schema?

508

---

How to do a full database export?

637

---

Why is oracle database so popular?

566

---

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1441

---

How to bring a tablespace offline?

543

---

Explain constraining triggers.

597

---

Is postgres faster than oracle?

561

---

What is snapshot is too old? Give and example for better understand.

1100

---

What is the data pump export utility?

645

---

What is the difference between I and G in Oracle?

603

---

Explain integrity constraint?

644

---

How can you merge two tables in oracle?

567

---

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

609

---