Quiz de SQL Básico

Quiz de SQL Básico

University

15 Qs

quiz-placeholder

Similar activities

2.3.1 Graph Traversal & Path Finding Algorithms

2.3.1 Graph Traversal & Path Finding Algorithms

12th Grade - University

20 Qs

Kuis Pemrograman Dasar

Kuis Pemrograman Dasar

University

20 Qs

Assignment 7 - Looping

Assignment 7 - Looping

University

16 Qs

ICT in Curriculum & Instructions

ICT in Curriculum & Instructions

University

10 Qs

Enterprise Applications

Enterprise Applications

University

15 Qs

DBMS

DBMS

University

15 Qs

Microsoft Access

Microsoft Access

10th Grade - Professional Development

10 Qs

Quiz3_DivideConquer_GreedyApproach

Quiz3_DivideConquer_GreedyApproach

University

10 Qs

Quiz de SQL Básico

Quiz de SQL Básico

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Francisco Dores

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

O que é SQL?

Uma linguagem de programação.

Uma linguagem de manipulação de dados.

Um banco de dados relacional.

Um sistema de gerenciamento de banco de dados.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Qual destes comandos SQL é usado para selecionar dados de uma tabela?

SELECT

INSERT

UPDATE

DELETE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Qual é o comando para inserir novos dados numa tabela?

ADD

INSERT INTO

PUT

UPDATE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Qual a sintaxe correta para selecionar todos os dados de uma tabela chamada "employees"?

SELECT all FROM employees;

SELECT * FROM employees;

GET all FROM employees;

EXTRACT * FROM employees;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Como você selecionaria apenas os registros onde a coluna "age" é maior que 30?

SELECT * FROM table WHERE age >= 30;

SELECT * FROM table HAVING age >= 30;

SELECT * FROM table GROUP BY age;

SELECT * FROM table WHERE age > 30;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Qual comando SQL retorna a soma de uma coluna numérica chamada "salary"?

SUM(salary);

SELECT SUM(salary) FROM table;

SELECT ADD(salary) FROM table;

TOTAL(salary);

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Qual consulta retorna o número total de registros de uma tabela chamada "customers"?

SELECT * FROM customers;

SELECT COUNT(*) FROM customers;

SELECT SUM(*) FROM customers;

SELECT TOTAL(*) FROM customers;

Create a free account and access millions of resources

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?