what is data independence exactly? give an example

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.

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign values to data fields in record variables?

574


How to use "if" statements on multiple conditions?

711


What is catalog in Oracle?

632


How do I limit the number of rows returned by an oracle query after ordering?

616


How to invoke the data pump export utility?

553






List out the difference between commit, rollback, and savepoint?

610


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

513


How to retrieve the count of updated rows?

568


How to convert raw data type into text in oracle? Explain

595


What is a named program unit?

572


What are the numeric comparison operations?

624


What are the restrictions on external table columns?

541


How to run create database statement again?

613


Explain the use of owner option in exp command.

561


What are the logical operations?

669