ANSWERS: (B) Data Manipulation Commands:
1. Insert the last 3 rows shown into the EMP table.
INSERT into emp ( emp_num, emp_fname, emp_lname, job_class, hiredate )
VALUES
( 106, 'William', 'Smithfield', 'PRG', '10/31/2002' ),
INSERT into emp ( emp_num, emp_fname, emp_lname )
VALUES
( 114, 'Annelise', 'Jones' )
INSERT into emp ( emp_num, emp_lname )
VALUES ( 118, 'Frommer' )
2. Update the employee fname to Jim instead of James for employee 118
(Note: if no WHERE clause is used, then all records are updated)
UPDATE emp
SET emp_fname = 'Jim'
WHERE emp_num = 118
3. Update the Database Designer chg_hour value by 10%
UPDATE job
SET chg_hour = chg_hour * 1.1
WHERE job_class = 'Database Designer'
4. Remove the row from the job table for job code PRG
( Note: if no WHERE clause is used, then all records are deleted )
DELETE
FROM job
WHERE job_code = 'PRG'