Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430

Consider the table STUDENT given below:RollNoNameClassDOBGenderCityMarks1AnandXI6/6/97MAgra4302ChetanXII7/5/94MMumbai4603GeetXI6/5/97FAgra4704PreetiXII8/8/95FMumbai4925SaniyalXII8/10/95MDelhi3606MaakhiyXI12/12/94FDubai2567NehaX8/12/95FMoscow3248NishantX12/6/95MMoscow4291. State the command that will give the output as :NameAnandChetanGeetPreetii. select name from student where class=’XI’ and class=’XII’;ii. select name from student where not class=’XI’ and class=’XII’;iii. select name from student where city=”Agra” OR city=”Mumbai”;iv. select name from student where city IN(“Agra” “Mumbai”);Choose the correct option:a. Both (i) and (ii).b. Both (iii) and (iv).c. Any of the options (i) (ii) and (iv)d. Only (iii)(2). What will be the output of the following command?Select * from student where gender =”F” order by marks;+(a) RollnoNameClassDOBGenderCityMarks4376PreetiGeetNehaMaakhiyXIIXIXXI8/8/956/5/978/12/9512/12/94FFFFMumbaiAgraMoscowDubai492470324256 (b)RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492(c)GenderMarksFFFF256324470492(d) GenderMarksFFFF492470324256

(1)  b. Both (iii) and (iv) (2) b. Rollno Name Class DOB Gender City Marks 6 7 3 4 Maakhiy Neha Geet Preeti XI X XI XII 12/12/94 8/12/95 6/5/97 8/8/95 F F F F Dubai Moscow Agra Mumbai 256 324 470 492