【单选题】dept表和locations表的结构如下: dept表: Name Null? Type dept_id decimal(4) dept_name not null varchar(30) manager_id decimal(6) location_id decimal(4) city ...
A.
update dept set city=any(select city from locations)
B.
update dept set city=(select city from locations) where dept.location_id=locations.location_id
C.
update dept set city=(select city from locations where dept.location_id=locations.location_id)
D.
update dept set city=all(select city from locations) where dept.location_id=locations.location_id
【简答题】阅读理解。 Many do-it-yourself homeowners are interested in trying out solar power to learn about the technology and perhaps to provide energy for limited-use applications. There are a variety of ways to f...
【单选题】dept表和locations表的结构如下: dept表: Name Null? Type dept_id number(4) dept_name not null varchar2(30) manager_id nubmer(6) location_id number(4) city ...
A.
update dept set city=any(select city from locations)
B.
update dept set city=(select city from locations) where dept.location_id=locations.location_id
C.
update dept set city=(select city from locations where dept.location_id=locations.location_id)
D.
update dept set city=all(select city from locations) where dept.location_id=locations.location_id