Answer 2
In SQL query with location transparency the end user must specify the database fragment name but does not need to specify where those fragments are located.
Fragmentation transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned. Therefore, neither fragment names nor fragment locations are specified prior to data access.
Local mapping transparency exists when the end user or programmer must specify both the fragment names and their locations.