SELECT * FROM besucher |_____| ID > 15;
mysql-Statements

Quiz
•
Computers
•
10th Grade
•
Medium

Ruedi Schenk
Used 9+ times
FREE Resource
14 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
1 min • 1 pt
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Welches ist das Platzhalterzeichen für beliebigen Text in MySQL?
*
%
&
\&
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Wie wählen Sie die Spalte Vorname aus einer Tabelle mit Namen 'Personen' aus?
SELECT Personen.Vorname
EXTRACT Vorname FROM Personen
SELECT Vorname FROM Personen
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Wie wählen Sie alle Spalten aus einer Tabelle mit Namen 'Personen' aus?
SELECT Personen*
SELECT ALL FROM Personen
SELECT [all] FROM Personen
SELECT * FROM Personen
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Wie wählen Sie alle Datensätze aus einer Tabelle mit Namen 'Personen' aus, deren Vorname Peter ist?
SELECT [ALL] FROM Personen WHERE Vorname LIKE 'Peter'
SELECT * FROM Personen WHERE Vorname <> 'Peter'
SELECT * FROM Personen WHERE Vorname = 'Peter'
SELECT * FROM Personen WHERE Vorname = Peter
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Ergänzen Sie das Statement, um Anna Schmidt zu selektieren.
INSERT INTO bewohner where ID = |____|
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Welches Statement für diese Abfrage?
SELECT ID,Vorname,Nachname, Gewicht FROM bewohner ORDER BY Gewicht
SELECT * FROM bewohner ORDER BY Gewicht DESC
SELECT ID,Vorname,Nachname, Gewicht FROM bewohner WHERE Gewicht > 50
SELECT * FROM bewohner WHERE Gewicht <=100
Create a free account and access millions of resources
Similar Resources on Quizizz
14 questions
SQL - Wiederholung

Quiz
•
9th - 12th Grade
12 questions
Keyboard Shortcuts

Quiz
•
1st - 12th Grade
10 questions
SQL

Quiz
•
10th Grade
18 questions
Photoshop Selections and More

Quiz
•
9th - 12th Grade
10 questions
Adobe Premiere Pro

Quiz
•
10th - 12th Grade
16 questions
Datenbanken - SQL und mehr

Quiz
•
9th - 10th Grade
13 questions
Access Theorie Tabellen

Quiz
•
10th - 11th Grade
10 questions
Textverarbeitung OnlyOffice

Quiz
•
8th - 10th Grade
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Computers
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade
65 questions
MegaQuiz v2 2025

Quiz
•
9th - 12th Grade
10 questions
GPA Lesson

Lesson
•
9th - 12th Grade
15 questions
SMART Goals

Quiz
•
8th - 12th Grade