Question:You have a database named 'marketnikkie', the backup of which is stored at 'D:\marketnikkie.bak' location on your server. Due to some electric fluctuations, the database gets corrupt. Which of the following is the correct query to restore your database?
A RESTORE DATABASE marketnikkie FROM DISK = 'D:\marketnikkie.bak'
B RESTORE DATABASE FROM DISK = 'D:\marketnikkie.bak'
C RESTORE DATABASE marketnikkie FROM = 'D:\marketnikkie.bak'
D RESTORE marketnikkie FROM DISK = 'D:\marketnikkie.bak'
E RESTORE DATABASE marketnikkie.mdf FROM DISK = 'D:\marketnikkie.bak'