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
How to fetch the row which has the max value for a column?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to experiment a data lock in oracle?
does the query needs a hint to access a materialized view?
How to calculate date and time differences in oracle?
How to unlock the sample user account in oracle?
How to build data dictionary view an new database?
what is insert all statement in sql
How to assign data of the deleted row to variables?
What is a system tablespace and when it is created?
How to generate query output in html format?
Explain compound trigger in oracle?
How can we view last record added to a table?
How to loop through a cursor variable?
How to join two tables in a single query using oracle?