Quiz | | | | A1: | d | | | | | A2: | b | | | | | A3: | b | | | | | A4: | a | | | | | A5: | c | Exercises | | | | A1: | select name , replace(job, 'Programmer', 'Analyst/Programmer') from employee; | | | | | A2: | insert into department values (NULL, 'Property Services'); insert into employee values (NULL, 'Fred Smith', 'DBA', last_insert_id()); | | | | | A3: | select max(workdate) from assignment; | |