Fragmentation transparency requires the least effort from the user to write SQL commands for a specific task,but requires the most work for the DBMS.

Question

Quizplus · Accepted Answer

Fragmentation transparency means that the user does not have to be aware of the physical distribution of data across multiple servers in a distributed database system. This requires more work from the DBMS to manage the distribution and consistency of data across servers, but it reduces the complexity for the user in terms of writing SQL commands. Therefore, the statement is true.

Fragmentation Transparency Requires the Least Effort from the User to Write