Write SQL statements to do the following:
Assume that the following table is created and stored in your database:
Staff (staffNo, name, post, salary, sex, DOB)
(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.
(a) UPDATE Staff
SET salary = salary * 1.05
WHERE post = ‘Manager’;
(b) DELETE FROM Staff
WHERE post = ‘salesman’;
(c) SELECT tablespace_name, pct_free, pct_used
FROM USER-TABLES
WHERE table_name = ‘Staff’;
You might also like to view...
Colors applied to a SmartArt graphic are coordinated with the presentation color theme
Indicate whether the statement is true or false
A webcast simulates the experience of attending a seminar only using the Internet
Indicate whether the statement is true or false
Using smaller images, called ____________________ pictures, saves space on the page and minimizes download time.
Fill in the blank(s) with the appropriate word(s).
Answer the following statements true (T) or false (F)
1. With multithreading the instruction stream is divided into several smaller streams, known as threads, such that the threads can be executed in parallel. 2. The function of switching applications and data resources over from a failed system to an alternative system in the cluster is referred to as failback. 3. Both clusters and symmetric multiprocessors provide a configuration with multiple processors to support high-demand applications. 4. The objective with NUMA is to maintain a transparent system wide memory while permitting multiple multiprocessor nodes, each with its own bus or other internal interconnect system. 5. A NUMA system without cache coherence is more or less equivalent to a cluster.