waht is meant data independence?
Answers were Sorted based on User's Feedback
Answer / siva k mahen
The ability to change the organization of the database
itself without changing the application software.
| Is This Answer Correct ? | 9 Yes | 2 No |
If you change internal low level abstraction database then they dont affect on higl level abstraction.
There are two types of data independance:
1) Physical data independance:
If you change physical level of data then they dont affect on logical level.
2) Logical data independance:
If you change logical level of data then they dont affect on view level
Summary: The ability to modify the schema defination in one level should not affect the schema defination in next higher level.
| Is This Answer Correct ? | 2 Yes | 0 No |
Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?
Explain about the process which takes place to execute a stored routine?
What is single tier architecture?
What is msdb database? : sql server architect
Not only RDBMS takes care of locating data it also
What is Weak Entity set?
What is BCNF (Boyce-Codd Normal Form)?
What is Data Independence?
What is an Extension of entity type?
What do you mean by atomicity and aggregation?
Why fastload support to empty table?
What is durability in DBMS?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)