SQL

1. What value will be stored in the lastName field of this record after this query is executed? (be careful)

INSERT INTO personnel (empID, lastName, firstName, jobTitle, hourlyWage) VALUES (67890, 'Michael', 'Peter', 'cleaner', 12.50)

	A;	67890
	B:	Michael
	C;	Peter
	D;	cleaner
	E:	12.50

2. What value will $connect have after the following statement is executed if the connection fails? $connect=mysqli($host, 'wbip', 'wbip123', 'test');

	A:	false
	B:	true
	C:	no value
D:		"Connection could not be completed"

3. Which of the last names will be matched by the WHERE clause in the following query?

SELECT empID from personnel WHERE lastName LIKE 'Jo_s'

'Jons' will be matched but 'Johns' and 'Johnson' will not be matched 'Jons' and 'Johns' will be matched but 'Johnson' will not be matched 'Jons', 'Johns' and 'Johnson' will all be matched None of these three last names will be matched