Quiz 2 4. With SQL, how do you select all the records from a table named "Students" where the "FirstName" is Jack and "Marks" are greater than 65? 1) SELECT * FROM Students WHERE 'FirstName'="Jack' AND 'Marks'>65; II) SELECT * FROM Students WHERE 'FirstName'='Jack', 'Marks'>65; III) SELECT * FROM Students WHERE FirstName="Jack' AND Marks>65; IV) none of them You can also see the options in the following figure 1) SELECT * FROM Students WHERE 'FirstName'='Jack' AND 'Marks'>65; 11) SELECT * FROM Students WHERE 'FirstName'='Jack', 'Marks'>65; III) SELECT * FROM Students WHERE FirstName='Jack' AND Marks>65; IV) none of them a) II b) IV I III Leave blank Quiz 2 5. Which of the following statement displays all the cities with the condition, temperature and hummidity whose hummidity is in the range of 60 to 75 from the "weather" table? 1) SELECT * FROM weather WHERE hummidity IN (60 to 75) 11) SELECT * FROM weather WHERE hummidity BETWEEN 60 AND 75 III) SELECT * FROM weather WHERE hummidity NOT IN (60 to 75) IV) SELECT * FROM weather WHERE hummidity NOT BETWEEN 60 AND 75 a) IV II 1 d) III Leave blank Close Quiz 2 6. Following Student table and tuple realtional calculus expression is given to you. After running this query what will be displayed as output ? Student mat_no firstname 1005 Clark 2832 Louise 4512 Lex 5119 Charles 6676 Erik 8024 Jeanne 9876 Logan lastname gender Kent m Lane f Luther m Xavier m Magnus m Gray f Black m EE Q:{t.firstname | Student(t) and t.mat_no > 6000 and t.gender = 'm'} a) Clark, Lex, Charles b) Clark, Lex, Charles, Erik, Logan c) Louise, Jeanne d) Erik, Jeanne, Logan Erik, Logan Leave blank )