5/18/2020Exam 3: DB Sys Concepts& Design - CS-6400-OAN16/21Which of the following clauses are mandatorily required in asyntactically correct SQL SELECT statement when querying adatabase table?a Select, a From and a Where clause a Select, a From, a Where, a Group By and an Order By clause a Select and a From clause a Select, a From, a Where and a Group By clause 0 / 4 ptsQuestion 21IncorrectIncorrectHow many rows are returned by the following query? select distinct r.cemailfrom reservation r, reservation swhere r.cemail = s.cemail and (r.startdate -4 / 4 ptsQuestion 22Hypothetically assume that none of the attributes in therelational schema are set as NOT NULL and that the existingprimary keys are utilized. Which of the following SQLstatements will correctly insert a new row into a table?
5/18/2020Exam 3: DB Sys Concepts& Design - CS-6400-OAN17/217 / 7 ptsQuestion 23Consider the original database state. After executing thefollowing Update statement update Toolsset deposit = deposit * 0.5whereoriginalprice >2000and toolid not in (select toolid from reservetools);What would be the new state of the Tools table? (Enter youranswer as a whole number.)
5/18/2020Exam 3: DB Sys Concepts& Design - CS-6400-OAN19/21Answer 7:704 / 4 ptsQuestion 24After the Tools table has been updated using the SQL in theprevious question, what toolid(s) would be returned by thefollowing query? (The previous button will allow you to revisitthe previous question.)Select toolid from tools wheredeposit > 65and deposit < 95;104 and 107 104 104, 106 and 107 105 No toolid(s) are returned 5 / 5 pts