
Quiz Prático de SQL
Authored by JULIANA CARVALHO
Computers
Professional Development
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual comando SQL é utilizado para criar um novo banco de dados chamado "escola"?
CREATE TABLE escola;
CREATE DATABASE escola;
INSERT INTO escola;
ALTER DATABASE escola;
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual comando insere um novo registro na tabela "alunos" com os valores: nome = 'João', idade = 18?
INSERT alunos VALUES ('João', 18);
INSERT INTO alunos (nome, idade) VALUES ('João', 18);
ADD INTO alunos VALUES ('João', 18);
UPDATE alunos SET nome = 'João', idade = 18;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Como selecionar todos os registros da tabela "produtos" onde o preço é maior que 100?
SELECT * FROM produtos WHERE preco > 100;
SELECT * FROM produtos WHERE preco = 100;
SELECT * FROM produtos WHERE preco < 100;
SELECT * FROM produtos;
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual comando atualiza o campo "email" para 'novo@email.com' do usuário com id = 5 na tabela "usuarios"?
UPDATE usuarios SET email = 'novo@email.com' WHERE id = 5;
UPDATE usuarios email = 'novo@email.com' WHERE id = 5;
ALTER usuarios SET email = 'novo@email.com' WHERE id = 5;
SET usuarios email = 'novo@email.com' WHERE id = 5;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Como excluir todos os registros da tabela "vendas" onde a quantidade é menor que 10?
DELETE FROM vendas WHERE quantidade < 10;
REMOVE FROM vendas WHERE quantidade < 10;
DROP FROM vendas WHERE quantidade < 10;
DELETE vendas WHERE quantidade < 10;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Qual comando retorna todos os nomes dos clientes que começam com a letra 'A' na tabela "clientes"?
SELECT nome FROM clientes WHERE nome LIKE 'A%';
SELECT nome FROM clientes WHERE nome = 'A';
SELECT nome FROM clientes WHERE nome LIKE '%A%';
SELECT nome FROM clientes WHERE nome IN ('A');
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Como alterar a tabela "funcionarios" para adicionar uma nova coluna chamada "departamento" do tipo VARCHAR(50)?
ALTER TABLE funcionarios ADD departamento VARCHAR(50);
UPDATE funcionarios ADD departamento VARCHAR(50);
ALTER funcionarios ADD departamento VARCHAR(50);
ADD COLUMN departamento VARCHAR(50) TO funcionarios;
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
25 questions
IT support level-1 (MCQ-1)
Quiz
•
Professional Development
28 questions
[DP-900] Módulo 02 - Dados relacionais
Quiz
•
Professional Development
28 questions
Bases de datos
Quiz
•
Professional Development
35 questions
CHAPTAR-12 MCQ
Quiz
•
Professional Development
30 questions
CompTIA A+ (Core 2) Part 1
Quiz
•
Professional Development
30 questions
Java Programming Fundamentals
Quiz
•
Professional Development
25 questions
Integrative Programming - Long Quiz (Midterm)
Quiz
•
Professional Development
25 questions
Visual Basic Quiz
Quiz
•
Professional Development
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
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
15 questions
LOTE_SPN2 5WEEK3 Day 2 Itinerary
Quiz
•
Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
42 questions
LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3
Quiz
•
Professional Development
6 questions
Copy of G5_U6_L3_22-23
Lesson
•
KG - Professional Dev...
20 questions
Employability Skills
Quiz
•
Professional Development