
Podstawy SQL w Access
Authored by Ewelina Kamińska
Computers
10th Grade
Used 3+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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
Access all questions and much more by creating a free account
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
15 questions
Lua Review Corona SDK with Notepad++
Quiz
•
10th - 12th Grade
10 questions
STM BTEC DIT 3- 5. Maintenance, set-up, performance p152
Quiz
•
9th - 11th Grade
10 questions
Adobe Illustrator Tools
Quiz
•
10th Grade
10 questions
Q1 M 2 - TOPIC 2 / Check your understanding
Quiz
•
10th Grade
10 questions
NETWORK TOPOLOGY
Quiz
•
10th Grade
16 questions
Python Basics
Quiz
•
KG - University
20 questions
Cambridge Nationals LO6
Quiz
•
10th Grade
20 questions
Python Recap
Quiz
•
7th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade