18) The Personnel table contains a Name column with data type VARCHAR[30). a) This column can store character data up to a maximum of 30 characters. b) This column must store character data that is at least 30 characters long, c) The VARCHAR data type is replaced by the CHAR data type. d) This column must store character data that is exactly 30 characters long 19) Which statement reports on unique PID values from the Personnel table? a) SELECT DISTINCT PID FROM Personnel; b) SELECT PID FROM Personnel; c) SELECT UNIQUE PID FROM Personnel d) SELECT DISTINCT PID, JID FROM Personnel; 20) Which of the following returns all columns and rows of data from the Employees table. a) SELECT * FROM Employees; b) SELECT ALL FROM Employees; c) SELECT % FROM Employees; d) SELECT * FROM Employees; 21) Choose the query that extracts the lastName, JID, and Salary values from the Employees table for records having JID values of either JID 2673 or JID2412 and having Salary values in the range of $2000 to $ $5000. The SELECT and FROM clauses are SELECT lastName, JID, Salary FROM Employees a) WHERE JID IN (TID2673", JID2412') AND SALARY BETWEEN 2000 AND 5000; b) WHERE JID IN ('11D2673","ID2412") AND SALARY > 2000 AND SALARY 2000 AND SALARY