Answer Posted / monika

Data independance:
It includes the isolation of data from application program.
There are 2 types of data independance:
1.Logical data independance:
The ability to change the conceptual schema without
altering the external schema or application programs.
2.Physical data independance:
It is ability to change the internal schema without
changing the conceptual or external schema.

Differentiate between pre-select and pre-query?

1055

---

How to convert a date to char in oracle? Give one example.

1003

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

956

---

Name the three major set of files on disk that compose a database in Oracle?

1066

---

What is an anonymous block?

1158

---

what is meant by magic query

2136

---

How to start a new transaction in oracle?

1016

---

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

1996

---

What is an oracle user account?

932

---

What is Segment Advisor in Oracle?

1051

---

How to pass parameters to procedures in oracle?

997

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2068

---

What is dual table oracle?

926

---

Explain temporal data types in oracle

1044

---

How to define an explicit cursor in oracle?

989

---