In distributed database, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A…
In distributed database, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify :
Show answerHide answer
Correct answer: (B) Fragments
Explanation
With location transparency the user does not need to know where the data is stored, but still needs to know how the data is fragmented; so a SQL query needs to specify fragments. Fragmentation transparency is the highest level, where the user does not even need to know that the database is partitioned.