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.

What is a user account in oracle?

1120

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

---

what is the use of system.effective.date variable in oracle?

1113

---

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

1073

---

Where is the export dump file located?

1156

---

What do you mean by merge in oracle and how can we merge two tables?

1049

---

Why do we need oracle client?

947

---

What is a static data dictionary in oracle?

1112

---

How to call a sub procedure?

1093

---

Explain the characteristics of oracle dba?

1120

---

How to convert characters to dates in oracle?

1097

---

What is the dynamic sql in oracle?

1071

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2061

---

What is the usage of save points in oracle database?

964

---

What is max rowid in oracle?

1025

---