Question

Assume that the following table is created and stored in your database:

Answer 1

Answer:

a. update Staff set salary=salary*1.05 where position='manager'

b. delete from Staff where position='salesman'

c. delete from Staff where name='Smith' and staff_no=17

d. insert into Staff (staff_no, name, position, salary, sex) values (18, 'Johnson', 'salesman', 2500, 'F')

e. update Staff set salary=2000 where job_id like '5%'

Explanation:

To update a column in a table 'update' command is used.

To remove a record from the table 'delete' command is used

To add a new record to the table 'insert into' command is used.