Iniciação a MySQL - Aula 1
Authored by David Almeida
Computers
9th - 12th Grade
Used 48+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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?
