which of the following SQL statement is used to remove a log file called logfile1 from a database called DB1?

 Posted by Bandi on 8/29/2017 | Category: Sql Server Interview questions | Views: 957 | Points: 40
Select from following answers:
  1. ALTER DATABASE DB1 REMOVE FILEGROUP logfile1
  2. ALTER DATABASE DB1 REMOVE FILE logfile1
  3. ALTER DATABASE DB1 MODIFY FILE (NAME=logfile1, FILEGROWTH=0MB)
  4. ALTER DATABASE Name1 MODIFY FILE (NAME=testfile1, SIZE=0MB)
  5. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response