User cannot open the layer file and see the data path to determine if the layer is to be added with absolute or relative paths, there are additional flags. In the provided test case, if the layer file is saved in the same location as the database, and user move the database and layer file together, then add the layer file to a map. The layer data source references the new data location.