Search Header Logo

Iniciação a MySQL - Aula 1

Authored by David Almeida

Computers

9th - 12th Grade

Used 48+ times

Iniciação a MySQL - Aula 1
AI

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?