以下是INVENTORY(库存)表的结构和表中所存储的数据：
INVENTORY
|
| Column Name | ID_NUMBER | DESCRIPTION | MANUFACTURER_ID | QUANTITY | PRICE | ORDER_DATE |
| Key Type | PK | | FK | | | |
| Nulls/Unique | NN, U | NN | NN | | | |
| FK Table | | | MANUFACTURER | | | |
| FK Column | | | ID_NUMBER | | | |
| Datatype | NUM | VARCHAR2 | VARCHAR2 | HUM | HUM | DATE |
| Length | 9 | 25 | 25 | 9 | 8, 2 | |
计划将描述为Cable的所有产品的价格提高10%并且修改描述为“Copper Wire”的全部产品的价格等于描述为Cable产品的价格，这些操作要在一个语句中完成，请问将使用如下的哪个语句
A．UPDATE inventory SET price =
(SELECT
price * 1.10
FROM inventory
WHERE description=’Cable’)
WHERE description IN(’Copper Wire’, ’Cable’);
B．UPDATE inventory SET price =
(SELECT
price * .10
FROM inventory
WHERE description=’Cable’)
WHERE description IN(’Copper Wire’，’Cable’);
C．UPDATE inventory SET price =
(SELECT
price * 1.10
FROM inventory
WHERE description=’Cable’);
D．UPDATE inventory SET price =
(SELECT
price * 1.10
FROM inventory
WHERE description=’Cable’
OR description=’Copper Wire’)
WHERE description=’Cable’)
