Hi Patrick,
maybe but this will lead to a wrong answer (as in my case). So - I'm not crazy about the points but the answers are ALL wrong from the Syntax!
Query 1: no comment 🙂
Query 2: ADD FILE does not work with "NEWNAME"-Parameter
Query 3: ALTER DATABASE does not have a Parameter called OLDNAME
Query 4: no comment 🙂
Any of the answers may lead to a wrong decision.
If you are concentrated to the MODIFY FILE only (which is nearest to the answer) you will fail (as I did).
I've tuned out all ADD FILE commands.
However - let's see what Steve will do.
Have a wonderful Sunday and all the best to the sqlservercentral-community...
Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)