
Domande di SQL
Quiz
•
Computers
•
2nd Grade
•
Practice Problem
•
Hard
Jessica Zangari
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cosa fa il comando SELECT in SQL?
Elimina dati
Aggiunge tabelle
Visualizza dati
Modifica colonne
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale parola chiave serve per indicare la tabella da cui leggere i dati?
TABLE
SELECT
WHERE
FROM
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
La clausola WHERE serve a:
Ordinare i risultati
Filtrare i dati
Mostrare la prima riga
Rinominare una tabella
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale query restituisce tutti i dati dalla tabella "Clienti"?
SELECT ALL Clienti;
GET * FROM Clienti;
SELECT * FROM Clienti;
SELECT FROM Clienti;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Come si scrive una query per ottenere nome e cognome dalla tabella "Utenti"?
SELECT nome + cognome FROM Utenti;
SELECT nome, cognome FROM Utenti;
SHOW nome, cognome IN Utenti;
SELECT (nome, cognome) IN Utenti;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Cosa significa l’asterisco (*) nella clausola SELECT?
Somma tutti i valori
Seleziona tutte le colonne
Seleziona solo i numeri
Filtra le righe duplicate
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Quale query restituisce i prodotti con prezzo maggiore di 100?
SELECT * FROM Prodotti WHERE prezzo > 100;
GET * FROM Prodotti WHERE prezzo > 100;
SELECT FROM Prodotti WHERE prezzo > 100;
SELECT prezzo > 100 FROM Prodotti;
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
15 questions
I.T. Quiz Bowl 2020 (I.T. Week '20)
Quiz
•
1st - 2nd Grade
15 questions
Systems Architecture
Quiz
•
KG - 9th Grade
20 questions
Parts of Computer
Quiz
•
2nd Grade
10 questions
Coding - Computer Programming
Quiz
•
KG - University
10 questions
Keyboard -Special Keys
Quiz
•
2nd Grade
12 questions
Intro to Scratch 2
Quiz
•
KG - University
10 questions
Computer Essentials
Quiz
•
2nd - 6th Grade
20 questions
Revision on KolourPaint
Quiz
•
2nd Grade
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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
Discover more resources for Computers
22 questions
Equal Groups and Arrays
Quiz
•
2nd Grade
10 questions
Life Cycle of a Frog
Quiz
•
1st - 2nd Grade
10 questions
Exploring Rosa Parks and Black History Month
Interactive video
•
1st - 5th Grade
20 questions
Counting Coins
Quiz
•
2nd Grade
20 questions
Place Value
Quiz
•
KG - 3rd Grade
30 questions
DA Math Mania Bowl - Primary
Quiz
•
2nd Grade
19 questions
Subject-Verb Agreement
Quiz
•
2nd - 5th Grade
10 questions
Harriet Tubman
Quiz
•
2nd - 3rd Grade
