• I agree. Query 3 is the MODIFY FILE while Query 2 is ADD FILE:

    -- Query 1

    ALTER DATABASE AdventureWorks2012

    ADD FILE (NAME=ADW2012 REPLACES Adventureworks2012_data)

    [highlight=#ffff11]

    -- query 2

    ALTER DATABASE AdventureWorks2012

    ADD FILE (NAME=AdventureWorks2012_data, NEWNAME=AWD2012 );

    [/highlight]

    [highlight=#ffff11]

    -- query 3

    ALTER DATABASE AdventureWorks2012

    MODIFY FILE (OLDNAME=AdventureWorks2012_data, Newname= AWD2012);

    [/highlight]

    -- query 4

    ALTER DATABASE AdventureWorks2012

    ADD FILE (NEWNAME=AWD2012, OLDNAME=AdventureWorks2012_data );