Клиент серверные технологии (Курсовая работа - Информационная служба учета времени работы сотрудника), страница 6

from product p1

where p1.type='laptop' and not p1.maker 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 like 'laptop' and p1.maker not in (select maker from product p2 where p2.type = 'printer')

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Удалить все блокноты, выпускаемые производителями, которые не выпускают принтеры

(укажите 4 правильных ответа)

1 - delete from laptop where model in (select p1.model from product p1

left join product p2 on p1.maker=p2.maker and p2.type='printer' where p2.type is null)

2 - delete from laptop where model in (select p1.model from product p1

where p1.type='laptop' and p1.maker not 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 not p1.maker 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 like 'printer'))

6 - delete from laptop where exists (select p1.model from product p1

where laptop.model = p1.model and p1.type = 'laptop'

and p1.maker not in (select maker from product p2 where p2.type like 'printer')

ПРАВИЛЬНЫЕ ОТВЕТЫ:

delete from laptop where model in (select p1.model from product p1

left join product p2 on p1.maker=p2.maker and p2.type='printer' where p2.type is null)

delete from laptop where model in (select p1.model from product p1

where p1.type='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 like 'laptop' and p1.maker not in (select maker from product p2 where p2.type like 'printer'))

delete from laptop where exists (select p1.model from product p1

where laptop.model = p1.model and p1.type = 'laptop'

and p1.maker not in (select maker from product p2 where p2.type like 'printer')

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Производство принтеров производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 3 правильных ответа)

1 - update product set maker='Z'

where maker='A' and type ='printer'

2 - update product set maker='A'

where maker='Z' and type ='printer'

3 - update product set maker like 'Z'

where maker='A' and type ='printer'

4 - update product set maker='Z'

where maker like 'A' and type like' printer'

5 - update product set maker='Z'

where maker='A' and type in ('printer')

6 - update product set maker=Z

where maker=’A’ and type ='printer'

ПРАВИЛЬНЫЕ ОТВЕТЫ:

update product set maker='Z'

where maker='A' and type ='printer'

update product set maker='Z'

where maker like 'A' and type like' printer'

update product set maker='Z'

where maker='A' and type in ('printer')

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Производство блокнотов производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 4 правильных ответа)

1 - update product set maker='Z'

where maker='A' and type ='laptop'

2 - update product set maker='A'

where maker='Z' and type ='laptop'

3 - update product set maker=Z

from (select ‘Z’ as Z) as zz

where maker='A' and type ='laptop'

4 - update product set maker='Z'

where maker in ('A') and type in ('laptop')

5 - update product set maker=Z

where maker=A and type ='laptop'

6 - update product set maker= (select 'Z')

where maker='A' and type ='laptop'

ПРАВИЛЬНЫЕ ОТВЕТЫ:

update product set maker='Z'

where maker='A' and type ='laptop'

update product set maker=Z

from (select ‘Z’ as Z) as zz

where maker='A' and type ='laptop'

update product set maker='Z'

where maker in ('A') and type in ('laptop')

update product set maker= (select 'Z')

where maker='A' and type ='laptop'

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Все модели цветных принтеров производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 3 правильных ответа)

1 - update product set maker='Z' where maker='A' and model in

(select printer.model from printer inner join product pr on printer.model=pr.model where color=’y’)

2 - update product set maker='Z' where maker='A' and not exists

(select * from printer inner join product pr on printer.model=pr.model where color=’y’)

3 - update product set maker='Z' where maker='A' and model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’)

4 - update product set maker='Z' where model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’ and pr.maker = ‘A’)

5 - update product set maker='Z' where not exists

(select pr.model from printer inner join product pr on printer.model=pr.model where color=’y’ and pr.maker = ‘A’)

6 - update product set maker='Z' where exists (select pr.model from printer inner join product pr on printer.model=pr.model where color=’y’ and pr.maker = ‘A’)

ПРАВИЛЬНЫЕ ОТВЕТЫ:

update product set maker='Z' where maker='A' and model in

(select printer.model from printer inner join product pr on printer.model=pr.model where color=’y’)

update product set maker='Z' where maker='A' and model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’)

update product set maker='Z' where model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’ and pr.maker = ‘A’)

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Все модели цветных принтеров производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 3 правильных ответа)

1 - update product set maker='Z' where maker='A' and model not in

(select printer.model from printer inner join product pr on printer.model=pr.model where color=’y’)

2 - update product set maker='Z' where maker='A' and exists

(select * from printer inner join product pr on printer.model=pr.model where color=’y’ and product.model=pr.model)

3 - update product set maker='Z' where maker='A' and not model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’)

4 - update product set maker='Z' where model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’ and pr.maker = ‘A’)

5 - update product set maker='Z' where

exists (select pr.model from printer inner join product pr on printer.model=pr.model where color=’y’ and pr.maker = ‘A’ and product.model=pr.model)

6 - update product set maker='Z' where

not exists (select pr.model from printer inner join product pr on printer.model=pr.model where color=’y’ and pr.maker = ‘A’)

ПРАВИЛЬНЫЕ ОТВЕТЫ:

update product set maker='Z' where maker='A' and exists

(select * from printer inner join product pr on printer.model=pr.model where color=’y’ and product.model=pr.model)

update product set maker='Z' where model in

(select pr.model from printer inner join product pr on printer.model=pr.model and color=’y’ and pr.maker = ‘A’)

update product set maker='Z' where

exists (select pr.model from printer inner join product pr on printer.model=pr.model where color=’y’ and pr.maker = ‘A’ and product.model=pr.model)

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Производство принтеров производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 4 правильных ответа)

1 - update product set maker=case when type ='printer' then 'Z' else maker end

where maker='A'

2 - update product set maker=case when type ='printer' then Z else A end

where maker='A'

3 - update product set maker=case when type ='printer' and maker='A' then 'Z' else maker end

4 - update product set maker=case when type in ('printer') then 'Z' end where maker='A'

5 - update product set maker= (select case when type ='printer' then 'Z' else maker end)

where maker='A'

6 - update product set maker=case type when 'printer' then ‘Z’ else maker end

where maker='A'

ПРАВИЛЬНЫЕ ОТВЕТЫ:

update product set maker=case when type ='printer' then 'Z' else maker end

where maker='A'

update product set maker=case when type ='printer' and maker='A' then 'Z' else maker end

update product set maker= (select case when type ='printer' then 'Z' else maker end)

where maker='A'

update product set maker=case type when 'printer' then ‘Z’ else maker end

where maker='A'

<<< ---------------------------- >>>

Дисциплина «Базы данных» (см. схему на бумаге)

Производство принтеров производитель A передал производителю Z. Выполнить соответствующее изменение (обновление)

(укажите 2 правильных ответа)

1 - update product set maker=case when type ='printer' then Z else maker end

where maker='A'

2 - update product set maker=case when type ='printer' then Z else A end