Клиент серверные технологии (1084480), страница 5
Текст из файла (страница 5)
(укажите 4 правильных ответа)
1 - insert into pc (code, model, speed, price)
select code+20, convert(int, model)+1000, speed, price/1.5
from
(select min(code) code, model, max(speed) speed, max(price) price
from laptop group by model) as gr_lap
2 - insert into pc (code, model, speed, price)
select code, model, speed, price
from
(select min(code+20) code, convert(int, model)+1000 model, max(speed) speed, max(price/1.5) price
from laptop group by convert(int, model)+1000) as gr_lap
3 - insert into pc (code, model, speed, price)
select code, model, speed, price
from
(select min(code+20) code, convert(int, model)+1000 model, max(speed) speed, max(price/1.5) price
from laptop group by model) as gr_lap
4 - insert into pc (code, model, speed, price)
select code, model, speed, price
from
(select min(code) code+20, convert(int, model)+1000 model, max(speed) speed, max(price) price /1.5
from laptop group by model) as gr_lap
5 - insert into pc (code, model, speed, price)
select code, model, speed, price
from (select min(code) +20 code, convert(int, model)+1000, max(speed) speed, max(price) /1.5 price
from laptop group by convert(int, model)+1000) as gr_lap
6 - insert into pc (code, model, speed, price)
select min(code) +20, model+1000, max(speed), max(price) /1.5 from laptop group by model+1000
ПРАВИЛЬНЫЕ ОТВЕТЫ:
insert into pc (code, model, speed, price)
select code+20, convert(int, model)+1000, speed, price/1.5
from
(select min(code) code, model, max(speed) speed, max(price) price
from laptop group by model) as gr_lap
insert into pc (code, model, speed, price)
select code, model, speed, price
from
(select min(code+20) code, convert(int, model)+1000 model, max(speed) speed, max(price/1.5) price
from laptop group by convert(int, model)+1000) as gr_lap
insert into pc (code, model, speed, price)
select code, model, speed, price
from
(select min(code+20) code, convert(int, model)+1000 model, max(speed) speed, max(price/1.5) price
from laptop group by model) as gr_lap
insert into pc (code, model, speed, price)
select min(code) +20, model+1000, max(speed), max(price) /1.5 from laptop group by model+1000
<<< ---------------------------- >>>
Дисциплина «Базы данных» (см. схему на бумаге)
Для каждой группы блокнотов с одинаковым номером модели добавить запись в таблицу PC со следующими характеристиками:
код: минимальный код блокнота в группе +20;
модель: номер модели блокнота +1000;
ram: максимальный объем ram блокнота в группе *2;
hd: максимальный объем hd блокнота в группе *2;
cd: значение по умолчанию;
(укажите 3 правильных ответа)
1 - insert into pc (code, model, ram, hd)
select code+20, convert(int, model)+1000, ram*2, hd*2 from
(select min(code) code, model, max(ram) ram, max(hd) hd
from laptop group by model) as gr_lap
2 - insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code+20) code, convert(int, model)+1000 model, max(2*ram) ram, max(2*hd) hd
from laptop group by convert(int, model)+1000) as gr_lap
3 - insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code+20) code, convert(int, model)+1000 model, max(ram*2) ram, 2*max(hd) hd
from laptop group by model) as gr_lap
4 - insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code) code+20, convert(int, model)+1000 model, max(ram) 2*ram, max(hd) 2*hd
from laptop group by model) as gr_lap
5 - insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code+20) code, convert(int, model)+1000, max(ram*2) ram, max(hd*2) hd
from laptop group by convert(int, model)+1000) as gr_lap
6 - insert into pc (code+20, model+1000, ram*2, hd*2)
select code, model, ram, hd from
(select min(code) code, model, max(ram) ram, max(hd) hd
from laptop group by model) as gr_lap
ПРАВИЛЬНЫЕ ОТВЕТЫ:
insert into pc (code, model, ram, hd)
select code+20, convert(int, model)+1000, ram*2, hd*2 from
(select min(code) code, model, max(ram) ram, max(hd) hd
from laptop group by model) as gr_lap
insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code+20) code, convert(int, model)+1000 model, max(2*ram) ram, max(2*hd) hd
from laptop group by convert(int, model)+1000) as gr_lap
insert into pc (code, model, ram, hd)
select code, model, ram, hd from
(select min(code+20) code, convert(int, model)+1000 model, max(ram*2) ram, 2*max(hd) hd
from laptop group by model) as gr_lap
<<< ---------------------------- >>>
Дисциплина «Базы данных» (см. схему на бумаге)
Удалить из таблицы PC компьютеры, имеющие минимальный объем диска или памяти.
(укажите 2 правильных ответа)
1 - delete from pc
where hd=(select min(hd) from pc)
or ram=(select min(ram) from pc)
2 - delete from pc
where hd in (select min(hd) from pc)
or ram in (select min(ram) from pc)
3 - delete from pc
where (hd, ram) in (select min(hd), min(ram) from pc)
4 - delete from pc
where exists (select min(hd) from pc AS p1 where min(p1.hd)=pc.hd)
or exists (select min(ram) from pc AS p2 where min(p2.ram)=pc.ram)
ПРАВИЛЬНЫЕ ОТВЕТЫ:
delete from pc
where hd=(select min(hd) from pc)
or ram=(select min(ram) from pc)
delete from pc
where hd in (select min(hd) from pc)
or ram in (select min(ram) from pc)
<<< ---------------------------- >>>
Дисциплина «Базы данных» (см. схему на бумаге)
Удалить из таблицы PC компьютеры, имеющие одновременно минимальный объем диска и памяти.
(укажите 2 правильных ответа)
1 - delete from pc
where hd=(select min(hd) from pc) and ram=(select min(ram) from pc)
2 - delete from pc
where hd in (select min(hd) from pc) or ram in (select min(ram) from pc)
3 - delete from pc where code in
(select code from pc
right join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn
on 1=1
where pc.hd=min_hd and pc.ram=min_ram)
4 - delete from pc
where (hd, ram) in (select min(hd), min(ram) from pc)
5 - delete from pc
where (select hd=min(hd) from pc) and (select ram=min(ram) from pc)
6 - delete from pc
where exists (select min(hd) from pc AS p1 where min(p1.hd)=pc.hd)
and exists (select min(ram) from pc AS p2 where min(p2.ram)=pc.ram)
ПРАВИЛЬНЫЕ ОТВЕТЫ:
delete from pc
where hd=(select min(hd) from pc) and ram=(select min(ram) from pc)
delete from pc where code in
(select code from pc
right join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn
on 1=1
where pc.hd=min_hd and pc.ram=min_ram)
<<< ---------------------------- >>>
Дисциплина «Базы данных» (см. схему на бумаге)
Удалить из таблицы PC компьютеры, имеющие минимальный объем диска или памяти.
(укажите 4 правильных ответа)
1 - delete from pc where code in (select code from pc
full join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn on 1=1
where pc.hd=min_hd or pc.ram=min_ram)
2 - delete from pc where code in (select code from pc
cross join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn
where pc.hd=min_hd or pc.ram=min_ram)
3 - delete from pc where code in (select code from pc
inner join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn on pc.hd=min_hd or pc.ram=min_ram)
4 - delete from pc
where (select hd=min(hd) from pc) and (select ram=min(ram) from pc)
5 - delete from pc
where (select min(hd) from pc)=hd or (select min(ram) from pc) = ram
6 - delete from pc where hd = min(hd) or ram = min(ram)
ПРАВИЛЬНЫЕ ОТВЕТЫ:
delete from pc where code in (select code from pc
full join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn on 1=1
where pc.hd=min_hd or pc.ram=min_ram)
delete from pc where code in (select code from pc
cross join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn
where pc.hd=min_hd or pc.ram=min_ram)
delete from pc where code in (select code from pc
inner join (select min(hd) min_hd, min (ram) min_ram from pc) as min_zn on pc.hd=min_hd or pc.ram=min_ram)
delete from pc
where (select min(hd) from pc)=hd or (select min(ram) from pc) = ram
<<< ---------------------------- >>>
Дисциплина «Базы данных» (см. схему на бумаге)
Удалить все блокноты, выпускаемые производителями, которые не выпускают принтеры
(укажите 3 правильных ответа)
1 - delete from laptop where model in
(select p1.model
from product p1
where p1.type='laptop' and not exists(select model from product p2 where p1.maker=p2.maker and p2.type='printer')
)
2 - delete from laptop where model in
(select p1.model
from product p1
where p1.type='laptop' and not p1.maker in (select maker from product p2 where p2.type='printer')
)
3 - delete from laptop where model in
(select p1.model
from product p1
where p1.type='laptop' or p1.maker not in (select maker from product p2 where p2.type='printer')
)
4 - delete from laptop where model in
(select p1.model
from product p1
where p1.type='laptop' and not p1.maker = (select maker from product p2 where p2.type='printer')
)
5 - delete from laptop where model in
(select p1.model
from product p1
where p1.type like 'laptop' and p1.maker not in (select maker from product p2 where p2.type = 'printer')
ПРАВИЛЬНЫЕ ОТВЕТЫ:
delete from laptop where model in
(select p1.model
from product p1
where p1.type='laptop' and not exists(select model from product p2 where p1.maker=p2.maker and p2.type='printer')
)
delete from laptop where model in
(select p1.model
![](https://s.studizba.com/z.php?f=/templates/si/i/noavatar.png&w=100&h=100&t=1"){kind=avatar}
