SQL lekcja 1-4

SQL lekcja 1-4

6th Grade

5 Qs

quiz-placeholder

Similar activities

Bài tập Tin học lớp 4

Bài tập Tin học lớp 4

1st - 12th Grade

10 Qs

Bài kiểm tra giữa kì 2 tin học 9 năm học 2022-2023

Bài kiểm tra giữa kì 2 tin học 9 năm học 2022-2023

6th - 8th Grade

10 Qs

Bài 11. Định dạng văn bản lớp 6

Bài 11. Định dạng văn bản lớp 6

6th Grade

10 Qs

Ôn lại kiến thức  Lớp 3 T13

Ôn lại kiến thức Lớp 3 T13

1st - 10th Grade

10 Qs

CLASS VI - ICT - WEEK 6

CLASS VI - ICT - WEEK 6

6th Grade

10 Qs

Chrome book short cuts

Chrome book short cuts

5th - 8th Grade

10 Qs

ինֆորմատիկա

ինֆորմատիկա

6th - 8th Grade

10 Qs

features in word

features in word

4th - 6th Grade

8 Qs

SQL lekcja 1-4

SQL lekcja 1-4

Assessment

Quiz

Computers

6th Grade

Medium

Created by

Maciej Dąbrowski

Used 4+ times

FREE Resource

AI

Enhance your content

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

5 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dana jest tabela Customer. Jak wyświetlić z niej tylko kolumny Name i Age?

SELECT FROM i inne słowa kluczowe z dużych liter! Nazwy np. kolumn z małych np age, name

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Do czego służy słowo kluczowe DISTINCT?

Do wyświetlania wyników (wierszy) bez duplikatów

Do ograniczenia liczby zwracanych wierszy

Do wyświetlania wszystkich wierszy razem z duplikatami

Nie ma takiego słowa kluczowego w języku SQL

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dana jest tabela Customer. Wyświetl z niej całe wiersze w których są osoby niepełnoletnie:

SELECT FROM i inne słowa kluczowe z dużych liter! Nazwy np. kolumn z małych np. age, name

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Dana jest tabela Customer. Jak wyświetlić z niej wszystkie miasta z "new" w nazwie?

SELECT * FROM Customer WHERE Address = "New";

SELECT * FROM Customer WHERE Address LIKE "%new%";

SELECT * FROM Customer WHERE Address LIKE "%new";

SELECT * FROM Customer WHERE Address = "New York";

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

Dana jest tabela Customer. Wyświetl z niej pierwsze 3 rekordy przy użyciu LIMIT:

SELECT FROM i inne słowa kluczowe z dużych liter! Nazwy np. kolumn z małych np. age, name