Gorchmynion SQL

Gorchmynion SQL

12th Grade

12 Qs

quiz-placeholder

Similar activities

Deddfau

Deddfau

10th - 12th Grade

15 Qs

Redes de ordenadores

Redes de ordenadores

1st Grade - University

12 Qs

Uned 1 Adran 1.3 - 1.5

Uned 1 Adran 1.3 - 1.5

12th Grade

15 Qs

Redes

Redes

12th Grade

7 Qs

Prog. no Des. de Sist. - SRP: Responsábilidade Única

Prog. no Des. de Sist. - SRP: Responsábilidade Única

12th Grade

10 Qs

Quiz zu RPA

Quiz zu RPA

12th Grade

13 Qs

Processo de admissão JA Senat

Processo de admissão JA Senat

1st - 12th Grade

15 Qs

Untitled Quiz

Untitled Quiz

12th Grade

10 Qs

Gorchmynion SQL

Gorchmynion SQL

Assessment

Quiz

Computers

12th Grade

Hard

Created by

T Wood

FREE Resource

12 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dyma gynllun cronfa ddata ar gyfer parciau thema a'u perchenogion.

Ysgrifennwch orchymun SQL er mwyn newid nifer ymwelwyr Alton Towers i 1400000.

Llinell gyntaf: ???

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dyma gynllun cronfa ddata ar gyfer parciau thema a'u perchenogion.

Ysgrifennwch orchymun SQL er mwyn newid nifer ymwelwyr Alton Towers i 1400000.

Llinell gyntaf: UPDATE parc_thema

Ail linell: ??

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dyma gynllun cronfa ddata ar gyfer parciau thema a'u perchenogion.

Ysgrifennwch orchymun SQL er mwyn newid nifer ymwelwyr Alton Towers (TP006) i 1400000.

Llinell gyntaf: UPDATE parc_thema

Ail linell: SET ymwelwyr as 1400000

Trydydd llinell: ??

4.

DRAG AND DROP QUESTION

1 min • 1 pt

Media Image

Dyma'r gorchymun SQL ar gyfer cywain tabl o wybodaeth yr holl brosiectau wedi cwblhau gan Mrs Wishi Washi:

​ (a)   ​ (b)   ​ FROM ​ (c)  

​ (d)   ​ (e)  

SELECT
*
Prosiectau
WHERE
RhA_Rheolwr = M1
RhA_Prosiect
FETCH
Rheolwyr
IF
Enw_Rheolwr = 'Mrs Wishi Washi'

5.

DRAG AND DROP QUESTION

1 min • 1 pt

Media Image

Gorchymun ar gyfer cael y RhA Apwyntiad a dyddiadau (yn unig) ar gyfer apwyntiadau gan y steilydd Cadi Mai.

​ (a)   Rha_Apwyntiad, Dyddiad ​ (b)  

​ (c)   ​ (d)  

SELECT
WHERE
RhA_Steilydd = S2
FROM Apwyntiadau
FETCH
PRINT
FROM Steilydd
Enw_Steilydd = 'Cadi Mai'
IF
WHEN

6.

DRAG AND DROP QUESTION

1 min • 1 pt

Media Image

Ysgrifennwch orchmynion SQL ar gyfer cywain tabl o'r holl brosiectau heblaw rhai sydd efo cyllid o £0 wedi trefnu o'r drytach lawr i'r rhatach.

SELECT ​ (a)   FROM Prosiectau

​ (b)   cyllid ​ (c)  

​ (d)   cyllid ​ (e)  

DESC
ORDER BY
*
>0
WHERE
IF
POSITIVE
ONLY
Rha_Prosiect

7.

DRAG AND DROP QUESTION

1 min • 1 pt

Media Image

Ysgrifennwch orchymun SQL i ychwanegu'r cofnod yma at y tabl:

'Animal Kingdom', sef parc thema yn Orlando efo 5500000 o ymwelwyr y flwyddyn., a'r rhif cwmni C1.

​ (a)   parciau ​ (RhA​​_Parc, Enw_Parc, RhA_Cwmni, Lleoliad, Ymwelwyr)

​ (b)   (​ (c)   , 'Animal Kingdom', ​ (d)   ,​ (e)   , 5500000)

INSERT INTO
VALUES
TP008
C1
Orlando
THESE
=
APPEND
RhA =
TP008 =

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?