How does Photos.app handle multiple libraries in relation to iCloud Photo Library?
Only one library can be the "system library", which in turn is used for iCloud Photo Library (if enabled), but you can have as many other libraries as you want.