Search Header Logo

Bases de dades UVE

Authored by Xènia Domènech

Other

University

Used 3+ times

Bases de dades UVE
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Tenim: USUARIS (Gestor, Ruta, Distribuidor) Escriu una query que unicament retorni les rutes sense duplicats

Select ALL ruta from Distribuidor

Select DISTINCT Ruta from Usuaris

Select DISTINCT Gestor from usuaris

Select from Ruta

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Tenint la taula USUARIS (Gestor, Ruta, Distribuidor) Escriu la query que retorna els gestors que comencin per C

Select Gestor from usuaris where gestor like ‘C%’

Select Ruta from usuaris where gestor like ‘C’

Select Gestor from usuaris where gestor like ‘C’

Select Gestor from usuaris where gestor start ‘C’

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

L’operador ___ s’usa per comprovar si un camp és un valor buit.

IS NULL

UNIQUE

IS EMPTY

NULL

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Volem passar la informació de USUARIS a USUARIS_NEW. Com ho fem?

Drop USUARIS

Insert from USUARIS to USUARIS_NEW

Create table USUARIS_NEW

select * into USUARIS_NEW from USUARIS

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Que estableix una primary key?

Integritat de les columnes

Integritat de les taules

Integritat dels registres

Integritat de les entitats

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Tenim: FACTURES (Pdv, Product, Quantitat). Quina query torna el num de pdv que han comprat mes de 2 packs de cocacola?

Select sum(Pdv) from FACTURES where product like '%Cola%' and quantitat>2

Select count(Pdv) from FACTURES where product like '%Cola%' and quantitat>2

Select sum(Pdv) from FACTURES where product like '%Cola%' and quantitat<2

Select distinct Pdv from FACTURES where product like 'Cola' and quantitat>2

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Quin és el motiu del naixement UVE?

Problemàtica de no visibilitat de Sell In

Problemàtica de no visibilitat de Sell Out

Plataforma per mostrar dades

Necesitat de plantejar noves promociones de producte

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?