
MySQL
Authored by Зухра Маметжан
Computers
2nd Grade
Used 8+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
SQL арқылы Persons кестесінің барлық өрістерінен деректерді қалай көрсетуге болады?
SELECT *.Persons
SELECT * FROM Persons
SELECT [all] FROM Persons
SELECT Persons
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Сұрыпталған нәтиже шығару үшін қандай SQL кілт сөзі пайдаланылады?
SORT BY
SORT
ORDER BY
ORDER
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Қандай SQL операторы тек бірегей мәндерді шығару үшін қолданылады?
SELECT UNIQUE
SELECT DIFFERENT
SELECT DISTINCT
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
"Аты" өрісіндегі мән "a" әрпінен басталатын "Тұлғалар" кестесіндегі барлық жазбаларды көрсету үшін SQL қалай пайдалануға болады?
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName='%a%'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Төмендегі сұраулардың қайсысы client кестесіндегі барлық жазбаларды қайтарады?
SELECT ALL FROM client
SELECT * FROM client WHERE clientID=2
SELECT * FROM client LIMIT 1
SELECT * FROM client
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
FirstName өрісінде Persons мәні бар тұлғалар кестесіндегі барлық жазбаларды көрсету үшін SQL тілін қалай пайдалануға болады?
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE FirstName<>'Peter'
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Аты өрісі бойынша кему ретімен сұрыпталған Persons кестесіндегі барлық жазбаларды көрсету үшін SQL қалай пайдалануға болады?
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons ORDER FirstName DESC
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
8 questions
Keyword Internet searches
Quiz
•
2nd - 5th Grade
10 questions
Parts of the computer - 1 Summative
Quiz
•
1st - 2nd Grade
10 questions
Bitmap v Vector Images
Quiz
•
KG - University
15 questions
Introduction to Windows 7
Quiz
•
KG - 2nd Grade
14 questions
Private vs Personal Info
Quiz
•
2nd - 4th Grade
10 questions
Excel
Quiz
•
1st - 3rd Grade
15 questions
6th Grade Media Quiz
Quiz
•
KG - University
10 questions
Cyber Safety Yr 2
Quiz
•
1st - 3rd Grade
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
14 questions
Contractions
Quiz
•
2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade
13 questions
Fractions
Quiz
•
1st - 2nd Grade
12 questions
2-Digit Subtraction with Regrouping
Quiz
•
2nd Grade
14 questions
Fractions
Quiz
•
2nd - 3rd Grade