
1TPB - BAZY DANYCH - SPRAWDZIAN
Authored by Marcin Gerwatowski
Other
12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
Jakie zapytanie SQL wyświetli tylko te rekordy, gdzie wartość w kolumnie 'wiek' jest większa niż 18?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
Które zapytanie SQL wyświetli rekordy z tabeli 'produkty', gdzie wartość w kolumnie 'kategoria' to 'elektronika'?
Evaluate responses using AI:
OFF
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Które z poniższych zapytań usunie rekordy z tabeli?
DELETE FROM tabela WHERE warunek;
REMOVE FROM tabela WHERE warunek;
DROP ROW FROM tabela WHERE warunek;
ERASE FROM tabela WHERE warunek;
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Które z poniższych zapytań usunie tabelę z bazy danych?
DELETE tabela;
REMOVE tabela;
DROP TABLE tabela;
ERASE TABLE tabela;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Które zapytanie SQL wyświetli liczbę rekordów w tabeli 'klienci'?
SELECT COUNT() FROM klienci;
SELECT NUMBER() FROM klienci;
SELECT SUM() FROM klienci;
SELECT TOTAL() FROM klienci;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Które zapytanie SQL wyświetli średnią wartość kolumny 'cena' w tabeli 'produkty'?
SELECT AVG(cena) FROM produkty;
SELECT MEAN(cena) FROM produkty;
SELECT SUM(cena) FROM produkty;
SELECT COUNT(cena) FROM produkty;
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Jakie zapytanie SQL usunie kolumnę 'wiek' z tabeli 'pracownicy'?
a) ALTER TABLE pracownicy DROP COLUMN wiek;
b) MODIFY TABLE pracownicy DROP COLUMN wiek;
c) CHANGE TABLE pracownicy DROP COLUMN wiek;
d) REMOVE COLUMN wiek FROM pracownicy;
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
16 questions
8525 AQA GCSE Computer Science 3.7.1 Relational databases
Quiz
•
7th - 12th Grade
20 questions
Quiz 2-Macroeconomics
Quiz
•
11th - 12th Grade
20 questions
Metacognition mixed with Fun
Quiz
•
10th - 12th Grade
15 questions
Income and Careers
Quiz
•
9th - 12th Grade
15 questions
Room Status
Quiz
•
11th - 12th Grade
15 questions
PRODUCT DEVELOPMENT EXAM
Quiz
•
12th Grade
20 questions
Research Skills General Quiz
Quiz
•
6th Grade - University
20 questions
Copyright, Fair Use & Creative Commons
Quiz
•
7th - 12th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Other
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade
10 questions
Valentine's Day Trivia
Quiz
•
9th - 12th Grade