what is data independence exactly? give an example

Answer Posted / mohammad ikram

Physical data independence
- the capacity to change the internal schema without
having to change the conceptual (or external) schema
- internal schema may change to improve the performance
(e.g., creating additional access structure)

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1792


What are temporal data types in oracle?

590


What are the predefined tablespaces in a database?

552


What is the difference between substr & instr functions?

591


How do I spool in oracle?

529






Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1571


What is the usage of control file in oracle?

599


How many types of tables are there in oracle?

572


What happens to the current transaction if a ddl statement is executed?

570


What are the extensions used by oracle reports?

568


what is insert all statement in sql

5483


What do you understand by a database object?

577


When do we use group by clause in a sql query?

562


Is it possible to insert comments into sql statements return in the data model editor ?

2061


How to use "if" statements on multiple conditions?

713