【单选题】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...
【简答题】A time capsule buried by Apple founder Steve Jobs 30 years ago has been discovered after its location was long forgotten.In 1983, the young tech innovator was attending a conference in Aspen when he a...
【单选题】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