You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

How would you DELETE records from the Items table with a "Chair" Type?

DELETE FROM Items WHERE Type = 'Chair'

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

Match the following SQL term with a description - FROM

The field and order used to sort the results

Match the following SQL term with a description - SELECT

The field and order used to sort the results

Match the following SQL term with a description - WHERE

The field and order used to sort the results

Match the following SQL term with a description - ORDER BY

The field and order used to sort the results

Write a code for the following: Return all romances that have an imdb_rating over 6.

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;

SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;

SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE name LIKE ‘day’;

RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

Quali tra le seguenti condizioni di ricerca sono corrette ?

Codice IN (1,2,3,4,5,6,7,8,9,10)

Quali tra le seguenti affermazioni sono vere?

La clausola ORDER BY viene inserita per ordinare i dati in base ai valori contenuti in una o più colonne

La clausola HAVING può essere usata solo con la clausola GROUP BY

La clausola GROUP BY viene inserita per ordinare i dati in base ai valori contenuti in una o più colonne

SELECT MAX(price) FROM PRODUCT will return how many rows?

As many rows that are in the table

Per ottenere i dati dei film usciti dopo il 2010

SELECT id, name, year FROM movies WHERE year > 2010;

SELECT id, name, year FROM movies WHERE year < 2010;

SELECT * FROM movies WHERE year > 2010;

SELECT id, name, year FROM movies WHERE YEAR > 2010;

Tutti i drammi usciti dopo il 2004.

SELECT * FROM movies WHERE genere = "dramma" AND year > 2004;

SELECT * FROM movies WHERE genere = 'dramma';

SELECT * FROM movies WHERE genere = <dramma> AND year < 2004;

SELECT * FROM movies WHERE rating = 7 AND LIMIT = 7

Ritorna il nome ed il genere di ogni film con un rating > 5 e anno uscita dopo il 2012.

SELECT name, genere FROM movies WHERE rating > 5 AND year > 2012;

SELECT * FROM movies WHERE rating > 5 AND year > 2012;

SELECT name, genere FROM movies WHERE rating < 5 AND year < 2012;

SELECT name, year FROM movies WHERE rating > 5 year > 2012;

la sintassi per creare una tabella è...

CREATE TABLE <table name> (field_name DATATYPE ... );

TABLE <table name> (field_name DATATYPE);

CREATE <table name> ( DATATYPE field_name);

SELECT <fieldname> FROM <table name)

È lo strumento per estrarre i dati secondo i criteri scelti dall’utente

Rappresenta una Interrogazione che si può chiedere al DB

Il formato più semplice è SELECT * FROM <Nome Tabella>

Fammi vedere la Materia che insegna il professore " Ionta " tradotta in SQL diventa

Select Materia From Docenti Where Cognome='Ionta'

Select Materia From Docenti Where Nome='Ionta'

Select Materie From Docente Where Cognome='Ionta'

Select Nomi, Classe From Alunni Where Classe in (Select Classe From Alunni Group By Classe Having Count(*) <10);

Ritorna i nomi con le loro classi degli alunni che sono in classi poco numerose (<10 alunni)

Ritorna i nomi degli alunni che sono in classi con pochi alunni (<10)

Ritorna i nomi con le loro classi degli alunni che sono in classi numerose

Ritorna le classi che hanno pochi alunni (<10)

Select Alunni, AVG(Voto) From Alunni Where AVG(Voto) >= 6 And Classe = "4B";

Ritorna gli alunni promossi della "4B"

Ritorna gli alunni rimandati della "4B"

Ritorna gli alunni Bocciatidella "4B"

Select Alunni, Voto From Alunni Where Classe = "4A" And Voto < (Select Avg (Voto) From Alunni Group By Classe Having Classe ="4A";)

Seleziona i peggiori alunni della 4A

Seleziona gli alunni della 4A con voto inferiore alla media della classe

Seleziona i più bravi della classe "4A"

Seleziona gli alunni della "4A" che hanno voti inferiori alla media della "4B"

Select Valore2 From Dati Where Valore1 In (Select Valore1 From Dati Where Valore1>100);

meglio la forma ridotta Select Valore2 From Dati Where Valore1 >100;

Selziona dalla Tabella Dati i valori della seconda colonna che hanno i corrispondenti valori della prima > 100

Selziona dalla Tabella Dati i valori della prima colonna che hanno i corrispondenti valori della seconda > 100

Selziona dalla Tabella Dati valori della seconda colonna che sono > 100

sql

Quiz

•

Computers

•

7th Grade

•

Practice Problem

•

Medium

•

CCSS

RI.5.10, RI.6.4, RI.7.4

+2

Standards-aligned

PERONE Cristina

Used 23+ times

FREE Resource

44 questions

Show all answers

1.

Add To

Update To

Add Into

Insert Into

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

Apple

Others

Already have an account?

Similar Resources on Wayground

45 questions

Sem 1 Final

Quiz

•

7th Grade

40 questions

Computer Hardware software

Quiz

•

6th - 8th Grade

40 questions

Grade 4 Ridge January General Knowledge Quiz

Quiz

•

4th - 7th Grade

39 questions

Cyber Foundations 1st 9wk Midterm Assessment

Quiz

•

7th Grade

40 questions

Computación 7,8 y 9

Quiz

•

7th - 11th Grade

39 questions

100th Day

Quiz

•

7th Grade

40 questions

Informatyka - test dla klasy 7

Quiz

•

7th Grade

40 questions

Power Point - Photoshop

Quiz

•

6th Grade - University

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

$fractions$

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 Computers

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

sql

44 questions

What does "SQL" stand for?

Which statement is used to extract data from a database?

If you were wanting to filter data, which clause would you use?

Using which word allows you to specify that more than one condition must be met in a query?

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

To remove a record from a table which SQL statement would you use?

Which statement allows us to add a record to a table?

Which character returns all the data found in a table?

Which word is missing from the following SQL statement?

Select * table_name

What is the correct order of clauses in a SQL statement?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

sql

44 questions

What does "SQL" stand for?

Which statement is used to extract data from a database?

If you were wanting to filter data, which clause would you use?

Using which word allows you to specify that more than one condition must be met in a query?

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

To remove a record from a table which SQL statement would you use?

Which statement allows us to add a record to a table?

Which character returns all the data found in a table?

Which word is missing from the following SQL statement?Select * table_name

What is the correct order of clauses in a SQL statement?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which word is missing from the following SQL statement?

Select * table_name