Databáze 2. ročník (2025/26) Course Materials & Test Answers | student.delta-studenti.cz

Monique požaduje změnu cen v tabulce copyffooditems:

– 'Strawberry Shake' z 3.59 na 3.75

– 'Fries' na 1.20

Která dvojice UPDATE příkazů je nejvhodnější?

Vyberte jednu odpověď.

UPDATE copyffooditems SET price = 3.75 WHERE description = 'Strawberry Shake'; UPDATE copyffooditems SET price = 1.20 WHERE description = 'Fries';

75%

UPDATE copyffooditems SET price = 3.75, price = 1.20 WHERE description IN ('Strawberry Shake','Fries');

UPDATE copyffooditems SET price = price + 0.16 WHERE description = 'Strawberry Shake'; UPDATE copyffooditems SET price = price + 1.20 WHERE description = 'Fries';

25%

UPDATE copyffooditems SET price = 3.75 WHERE description LIKE '%Shake%';

View this question

Crowdly

Databáze 2. ročník (2025/26)

Want instant access to all verified answers on student.delta-studenti.cz?