
Iniciação a MySQL - Aula 1
Quiz
•
Computers
•
9th - 12th Grade
•
Practice Problem
•
Hard
David Almeida
Used 48+ times
FREE Resource
Enhance your content in a minute
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual o comando que permite ordenar a tabela "alunos" por "Nome"?
SELECT * FROM alunos ORDER BY Nome
SELECT * FROM alunos ORDER Nome
SELECT * FROM alunos WHERE BY Nome
SELECT * FROM alunos WHERE Nome
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Indique o comando que mostre todos os alunos que tenham o "idAluno" menor que 5000.
SELECT * FROM alunos WHERE idAluno<5000
SELECT * FROM alunos WHERE idAluno<=5000
SELECT * FROM alunos<5000
SELECT * FROM alunos<=5000
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Indique o comando que permite consultar todos os alunos do sexo feminino.
SELECT * FROM alunos WHERE Sexo="F"
SELECT * FROM alunos ORDER Sexo="F"
SELECT * FROM alunos ORDER BY Sexo="F"
SELECT * FROM alunos WHERE BY Sexo="F"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual dos seguintes comandos permite filtrar o conteúdo da tabela "alunos" com todos os alunos de sexo masculino?
SELECT * FROM alunos WHERE Sexo="M"
SELECT * FROM alunos ORDER Sexo="M"
SELECT * FROM alunos WHERE Sexo="Masculino"
SELECT * FROM alunos ORDER BY Sexo="M"
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual dos seguintes comandos mostra a tabela "alunos" ordenada pelo campo "Nome" de forma ascendente?
SELECT * FROM alunos ORDER BY Nome
SELECT * FROM alunos ORDER BY Nome ASCENDENTE
SELECT * FROM alunos WHERE BY Nome
SELECT * FROM alunos WHERE BY Nome ASCENDENTE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Que comando permite ordenar de forma descendente a tabela "alunos" pelo campo "Nome"?
SELECT * FROM alunos ORDER BY Nome DESC
SELECT * FROM alunos ORDER BY Nome Order="DESC"
SELECT * FROM alunos WHERE BY Nome DESC
SELECT * FROM alunos WHERE BY Nome Order="DESC"
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Que comando permite executar uma consulta que ordene a tabela "alunos" pelo campo "DataNasc"?
SELECT * FROM alunos ORDER BY DataNasc
SELECT * FROM alunos ORDER BY DataNasc ASCENDENTE
SELECT * FROM alunos ORDER BY ASC DataNasc
SELECT * FROM alunos ORDER DataNasc
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
20 questions
Quizz SO
Quiz
•
12th Grade
21 questions
Y9 Creative iMedia RO81 Quiz Part 1
Quiz
•
9th Grade
17 questions
Basic Docs
Quiz
•
8th - 9th Grade
20 questions
CSS 10 - QUIZ
Quiz
•
10th Grade
15 questions
ôn tập chỉnh ảnh và làm phim
Quiz
•
11th Grade
16 questions
Kod Arahan
Quiz
•
9th - 11th Grade
20 questions
Yr 11 ICT quiz 1 Networks & Security
Quiz
•
10th - 11th Grade
16 questions
A2 Computer Science 4.10 Databases
Quiz
•
10th - 12th 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
