For the following queries, determine the minimum cost of the query (in I/Os), if you can have any number of secondary (also known as alternative-2) indexes available. Each index has to be on a single key attribute; composite keys are not allowed. a) select count(*) from employees where name = ‘John Smith’; b) select avg(salary) from employees where name = ‘John Smith’; c) select count(*) from employees where birthdate < ‘1-1-1980 00:00’;

Http is the protocol that governs communications between web servers and web clients (i.e. browsers). part of the protocol includes a status code returned by the server to tell the browser the status of its most recent page request. some of the codes and their meanings are listed below: 200, ok (fulfilled)403, forbidden404, not found500, server errorgiven an int variable status, write a switch statement that prints out the appropriate label from the above list based on status.