Solved

Assume That the Following Table Is Created and Stored in Your

Question 18

Essay

Assume that the following table is created and stored in your database:
Staff (staffNo, name, post, salary, sex, DOB)
Write SQL statements to do the following:
(a) Increment the salary of managers by 5%;
(b) Remove the records of all 'salesmen' from the Staff table;
(c) List the Staff table tablespace name, pctfree, and pctused.

Correct Answer:

verifed

Verified

(a)
UPDATE Staff
SET salary = salary *...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions