Answer Posted / mkjmkumar

Oracle Analyse a Query using two Approches
1. CBO
2. RBO

Cost Based Analyser is default when we do not in oracle
setup.

CBO picks up query output using witch have less cost

How do you find current date and time in oracle?

985

---

What are the advantages of oracle?

960

---

How to lock and unlock a user account in oracle?

1024

---

What is object data modeling?

903

---

How to install oracle database 10g xe?

964

---

Can the query output be sorted by multiple columns in oracle?

933

---

In oracle there is column command, how will you explain that?

966

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

976

---

How do you bind variables in oracle?

927

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2044

---

Define oracle database

991

---

How to calculate date and time differences in oracle?

990

---

Use of an integrity constraint is better to validate data. Explain

973

---

What is the oracle implicit cursor?

997

---

What privilege is needed for a user to delete rows from tables in another schema?

1017

---