Consultas e Comandos em SQL
Quiz
•
Instructional Technology
•
11th Grade
•
Practice Problem
•
Hard
SAMUEL FREITAS
FREE Resource
Enhance your content in a minute
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual comando SQL é utilizado para inserir linhas em uma tabela?
UPDATE
INSERT
DELETE
2.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
O que faz o comando SQL UPDATE?
Insere novos registros em uma tabela
Remove registros de uma tabela
Modifica registros existentes em uma tabela
Cria uma nova tabela no banco de dados
3.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual comando SQL é usado para remover dados de uma tabela?
UPDATE
INSERT
DELETE
4.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual é a função do comando SQL 'SELECT'?
Selecionar dados de um banco de dados
Inserir dados em um banco de dados
Atualizar dados em um banco de dados
Excluir dados de um banco de dados
5.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Qual é o comando SQL usado para criar uma nova tabela chamada 'lista_de_nomes' com colunas 'nome' e 'sobrenome'?
CREATE TABLE lista_de_nomes (nome VARCHAR(255), sobrenome VARCHAR(255));
INSERT INTO lista_de_nomes (nome, sobrenome) VALUES ('John', 'Doe');
SELECT * FROM lista_de_nomes;
DROP TABLE lista_de_nomes;
6.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Baseando-se nos dados já existentes na tabela contato, qual comando SQL é usado para inserir dados na tabela 'lista_de_nomes'?
INSERT INTO lista_de_nomes SELECT * FROM contato
UPDATE lista_de_nomes SET nome = (SELECT nome FROM contato)
DELETE FROM lista_de_nomes WHERE nome IN (SELECT nome FROM contato)
ALTER TABLE lista_de_nomes ADD COLUMN nome VARCHAR(255)
7.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Quais são as três principais cláusulas mencionadas no texto para consultas SQL?
SELECT, FROM, WHERE
INSERT, UPDATE, DELETE
JOIN, GROUP BY, ORDER BY
CREATE, ALTER, DROP
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
10 questions
Introducción tecnología
Quiz
•
7th - 11th Grade
10 questions
WORD
Quiz
•
1st Grade - Professio...
10 questions
Prompts IA
Quiz
•
9th - 12th Grade
10 questions
Requisitos de Software
Quiz
•
11th Grade
10 questions
MARKETIN DIGITAL
Quiz
•
1st Grade - University
10 questions
Estadistica % y probabilidad
Quiz
•
11th Grade
13 questions
Instrucțiuni simple C++
Quiz
•
9th - 12th Grade
13 questions
¿Cuánto sabes de POLLY POCKET?
Quiz
•
KG - Professional Dev...
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 Instructional Technology
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
13 questions
Model Exponential Growth and Decay Scenarios
Quiz
•
9th - 12th Grade
27 questions
7.2.3 Quadrilateral Properties
Quiz
•
9th - 12th Grade
7 questions
Amoeba Sisters Dihybrid Cross Punnett Square
Interactive video
•
9th - 12th Grade
10 questions
The Holocaust: Historical Overview
Interactive video
•
9th - 12th Grade
10 questions
Key Features of Quadratic Functions
Interactive video
•
8th - 12th Grade
