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:

Verified
(a)
UPDATE Staff
SET salary = salary *...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
UPDATE Staff
SET salary = salary *...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q8: (a)SQL*Plus environment variables are set to
Q9: (a) What is a 'table' and what
Q10: Oracle database consists of logical and physical
Q11: A relational database contains details about journeys
Q12: Write SQL*Plus commands to do the following:
Q13: (a) What is a SQL*Plus script? Why
Q14: The following tables form part of a
Q15: State the three primary uses of Oracle
Q16: The following tables form part of a
Q17: (a) What is a named block