
Podstawy SQL w Access
Quiz
•
Computers
•
10th Grade
•
Practice Problem
•
Medium
Ewelina Kamińska
Used 3+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie wyświetla wszystkie kolumny i rekordy z tabeli Klienci?
SELECT DISTINCT Miasto FROM Klienci;
SELECT TOP 5 * FROM Produkty;
SELECT Imie, Nazwisko FROM Klienci;
SELECT * FROM Klienci;
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie zwraca tylko różne wartości z kolumny Miasto?
SELECT TOP 5 Miasto FROM Klienci;
SELECT DISTINCT Miasto FROM Klienci;
SELECT Miasto FROM Klienci;
SELECT * FROM Klienci;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie słowo kluczowe służy do filtrowania danych w SQL?
SELECT
WHERE
ORDER BY
DISTINCT
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie wyświetla tylko Klientów z Warszawy?
SELECT * FROM Klienci WHERE Miasto = 'Wrocław';
SELECT * FROM Klienci WHERE Miasto = 'Kraków';
SELECT * FROM Klienci WHERE Miasto = 'Warszawa';
SELECT * FROM Klienci WHERE Miasto = 'Gdańsk';
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie sortuje Klientów rosnąco po nazwisku?
SELECT * FROM Klienci ORDER BY Nazwisko ASC;
SELECT * FROM Klienci ORDER BY Miasto DESC;
SELECT * FROM Klienci ORDER BY Nazwisko DESC;
SELECT * FROM Klienci ORDER BY Miasto ASC;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie zwraca 5 najdroższych produktów?
SELECT TOP 5 * FROM Produkty ORDER BY Cena ASC;
SELECT * FROM Produkty ORDER BY Nazwa;
SELECT TOP 5 * FROM Produkty ORDER BY Cena DESC;
SELECT * FROM Produkty WHERE Cena > 100;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Co oznacza operator BETWEEN w SQL?
Sprawdza, czy wartość znajduje się w przedziale
Sprawdza, czy wartość jest równa
Sprawdza, czy wartość jest większa
Sprawdza, czy wartość jest mniejsza
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Basic Parts of Speech EPS
Quiz
•
9th - 10th Grade
15 questions
Quiz 1
Quiz
•
1st - 12th Grade
14 questions
LA5.C5: Branching and Subroutines
Quiz
•
9th Grade - University
10 questions
A level Computer Science In-fix post-fix Reverse polish
Quiz
•
10th Grade - University
13 questions
Copyrights and Wrongs Assessment
Quiz
•
9th - 12th Grade
13 questions
Guess the Retro Computer 1
Quiz
•
KG - Professional Dev...
18 questions
SQA Presentations Quiz 1
Quiz
•
10th Grade
15 questions
# REVIEW 1 DATA TYPES
Quiz
•
10th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
