Answer Posted / yasi

Simple view derives data from only one table and contains NO functions or groups of data. And can perform DML operation through the view

Complex view derives data from many tables and contains functions or groups of data, It does not always allow DML operations through the view

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2242

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

915

---

what are the advantages of running a database in archive log mode?

2139

---

Difference between inner join vs where ?

976

---

Explain how are indexes update?

1013

---

Explain view?

976

---

What is oracle used for?

966

---

Briefly explain what is literal? Give an example where it can be used?

968

---

How to export data to a csv file?

1197

---

What are the logical operations?

1061

---

What is an oracle function?

1068

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2242

---

How to define an oracle sub procedure?

1047

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2503

---

What is oracle and what are its different editions?

1007

---