Answer Posted / suhaib yaseen shareef

data description is called schema.

Explain the function of optimizer in oracle?

596

---

What are the major difference between truncate and delete?

519

---

What is oracle update statement with inner join ?

583

---

What is truncate oracle?

531

---

How a database is related to tablespaces?

578

---

---

Explain self joins in oracle?

562

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

651

---

How to connect to oracle using service name instead of sid?

553

---

What are transaction isolation levels supported by oracle?

576

---

How to start your 10g xe server from command line?

548

---

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

1439

---

How to get maxsal , minsal, ename department wise in single query

1020

---

What is a sub query? What are its various types?

583

---

What is a dynamic performance view in oracle?

608

---

Is oracle an open source?

637

---