What is the difference between AND and OR in SQL queries?

'AND' requires all conditions to be true; 'OR' requires at least one condition to be true.

'AND' combines results from different tables; 'OR' combines results from the same table.

'AND' is used for sorting data; 'OR' is used for filtering data.

'AND' requires at least one condition to be true; 'OR' requires all conditions to be true.

What is a table field in SQL?

A table field in SQL is a column in a table that stores data.

A table field in SQL is a row in a table that stores data.

A table field in SQL is a database that contains multiple tables.

A table field in SQL is a command used to create a table.

How do you establish relationships between tables?

Establish relationships using primary and foreign keys.

Creating duplicate columns in each table.

Merging tables into a single entity.

Using only indexes to link tables.

What is the syntax for a basic SELECT query?

SELECT column1 AND column2 FROM table_name;

SELECT column1, column2 WHERE table_name;

FROM table_name SELECT column1, column2;

How can you sort results in descending order using ORDER BY?

Use ORDER BY column_name DESC to sort in descending order.

ORDER BY column_name DESCENDING for descending order.

Use ORDER BY column_name ASC to sort in ascending order.

ORDER BY column_name to sort without specifying order.

What happens if you try to insert a duplicate primary key?

The insertion will fail with a primary key constraint violation error.

The primary key will be automatically updated.

The insertion will succeed without any issues.

A warning will be issued, but the record will be added.

How do you use the WHERE clause with multiple conditions?

Use the WHERE clause with multiple conditions by combining them with AND/OR, e.g., WHERE condition1 AND condition2 OR condition3.

Use the WHERE clause only with a single condition.

Use the WHERE clause without any conditions.

Combine conditions using only NOT.

What is the purpose of a foreign key in a database?

To establish a link between two tables.

To uniquely identify a record in the same table.

To create indexes for faster queries.

To store large amounts of data.

How do you add a new table in a database with SQL?

CREATE TABLE table_name (column1 datatype, column2 datatype);

What does the COUNT function do in SQL?

Counts the number of rows that match a specified condition.

Counts the number of unique values in a column.

Counts the total number of columns in a table.

Counts the number of tables in a database.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT "FirstName" DESC

SELECT * FROM Persons SORT BY FirstName DESC

SELECT * FROM Persons ORDER FirstName ASC

With SQL, how can you insert a new record into the "Persons" table?

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

Retrieve the name and year of all movies before 2010

SELECT name, year FROM movies WHERE year < 2010;

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

SELECT * FROM movies WHERE year < 2010;

SELECT name, year WHERE YEAR < 2010;

Select all countries from America.

Select * from Countries where Continent="North America" OR Continent="South America"

Select * from Countries where Continent = "North America" AND "South America"

Select * from Continent = America

Select * from Countries where Continent= "North America" AND Continent= "South America"

Understanding SQL Concepts

Authored by Teacher TIC

Computers

10th Grade

Used 4+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

27 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for?

Standard Query Language

Simple Query Language

Structured Query Language

Structured Query List

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SELECT statement?

To delete data from a database.

To update existing records in a database.

To create new tables in a database.

To retrieve data from a database.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you filter records in SQL?

Apply the GROUP BY clause for filtering.

Utilize the JOIN clause to filter records.

Use the WHERE clause in SQL to filter records.

Use the SELECT statement to filter records.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function of the ORDER BY clause?

To limit the number of rows returned by a query.

To filter the result set of a query.

To group the result set of a query.

To sort the result set of a query.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Define a primary key in a database table.

A primary key is a unique identifier for records in a database table.

A primary key is an optional field in a database table.

A primary key can contain duplicate values in a database table.

A primary key is a type of foreign key in a database table.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a foreign key?

A foreign key is a type of primary key.

A foreign key is a unique identifier for a table.

A foreign key is a field that contains only null values.

A foreign key is a field in a table that links to the primary key of another table.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you insert data into a table in SQL?

INSERT INTO table_name (column1, column2) VALUES (value1, value2);

ADD RECORD TO table_name WHERE condition;

ADD NEW field_name TO table_name;

UPDATE table_name SET column1 = value1;

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

22 questions

representing numbers (lesson 1 plenary)

Quiz

•

6th Grade - University

23 questions

Special Project - Geometry Dash - QUIZ

Quiz

•

10th Grade

25 questions

Journey Inside

Quiz

•

9th - 11th Grade

25 questions

Introduction to IT

Quiz

•

5th - 10th Grade

22 questions

Evaluación Diagnóstica Diseño de Portales Web

Quiz

•

10th Grade

22 questions

Quiz - Análisis y Diseño 4to NS

Quiz

•

10th Grade

25 questions

SPREADSHEET

Quiz

•

10th Grade

22 questions

Xпр_Ал_лог

Quiz

•

9th - 12th 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

$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

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade