Given the following table:
STOCK
————————–
CATEGORY CHAR(1)
PARTNO CHAR(12)
DESCRIPTION VARCHAR(40)
QUANTITY INTEGER
PRICE DEC(7,2)
If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and
PRICE to zero, which of the following statements updates the STOCK table to indicate that all
items except those with CATEGORY of ‘S’ are temporarily out of stock?
A.
UPDATE stock SET description = ‘NULL’, quantity = 0, price = 0 WHERE category ‘S’
B.
UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category ‘S’
C.
UPDATE stock SET (description, quantity, price) = (‘null’, 0, 0) WHERE category ‘S’
D.
UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category ‘S’
UPDATE suppliers
SET supplier_name = ‘Apple’, product = ‘iPhone’
WHERE supplier_name = ‘RIM’;
EXAMPLE – UPDATE MULTIPLE TABLES
Let’s look at an UPDATE example that shows how to update multiple tables in an UPDATE statement. (Please note that this syntax is not valid in Oracle).
UPDATE suppliers, contacts
SET suppliers.status = ‘Active’,
contacts.note = ‘Also Supplier’
WHERE suppliers.supplier_id = contacts.contact_id;
0
0
‘-(—-column-name–+———————-+-+–)–=–(–+—+-expression-+—–+-+–)-‘
0
0