【单选题】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
【简答题】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