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
SELECT * FROM besucher |_____| ID > 15;
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 Wayground
18 questions
HTML & CSS

Quiz
•
10th - 12th Grade
10 questions
Was sind Medien?

Quiz
•
7th Grade - University
10 questions
RETI_1

Quiz
•
8th - 12th Grade
15 questions
Computer Systems / Hardware vs Software

Quiz
•
8th - 10th Grade
16 questions
Photoshop tools

Quiz
•
6th Grade - Professio...
19 questions
1.2 Memory

Quiz
•
9th - 11th Grade
15 questions
Quiz su Archivi e Database

Quiz
•
10th Grade
17 questions
Wh-Fragen aus 2. Klasse OMAI Schulbeginn

Quiz
•
1st - 12th Grade
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade