Quiz

1:	Which of the following queries selects all data stored in the client table? select * from client where clientID=2; select clientID, name, address, contactPerson, contactNumber from client; select * from client limit 1; select all from client;
2:	Which of the following queries selects all the programmers from the employee table? select * from employee where job='Programmer'; select * from employee having job='Programmer'; select * from employee where job='Programmer' group by job having job='Programmer'; select job from employee;
3:	Which of the following queries will not return the total number of employees in the employee table? select count(employeeID) from employee; select count(employeeID) as total from employee; select count(distinct employeeID) from employee; select count(employeeID) from employee group by employeeID;
4:	Where can we not use aliases? For columns For tables In the WHERE clause In the SELECT clause
5:	If we want to return the 15th through 20th rows from a query, the correct LIMIT clause is LIMIT 15, 20 LIMIT 14, 19 LIMIT 14, 5 LIMIT 15, 5