SQL SELECT

SQL SELECT

8th - 10th Grade

10 Qs

quiz-placeholder

Similar activities

Introduction to Networks

Introduction to Networks

6th - 8th Grade

14 Qs

ICT Java programming workshop

ICT Java programming workshop

9th Grade

10 Qs

Kuis Dadakan ;)

Kuis Dadakan ;)

10th Grade - University

15 Qs

analisis data dan visualisasi data

analisis data dan visualisasi data

10th Grade

10 Qs

Revision quiz on Access

Revision quiz on Access

8th Grade

12 Qs

J808 LO1 and LO2 planning project keywords / terms

J808 LO1 and LO2 planning project keywords / terms

9th - 11th Grade

15 Qs

21 Things Basics

21 Things Basics

7th - 8th Grade

10 Qs

حاسب 2

حاسب 2

10th Grade

15 Qs

SQL SELECT

SQL SELECT

Assessment

Quiz

Computers

8th - 10th Grade

Practice Problem

Medium

Created by

David Jonathan Alford

Used 299+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which statement will show all fields and records from the table called "celebs"?

SELECT * FROM celebs;

SELECT FROM celebs;

SELECT forename, surname FROM celebs;

SELECT celebs;

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SQL statement being run is:


SELECT player_name, score FROM leaderboard;


What is the name of the table in this query?

SELECT

player_name

score

leaderboard

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SQL statement being run is:


SELECT player_name, score FROM leaderboard;


How many columns of results will be shown when this query is run?

0

1

2

3

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement will show the names and heights of all basketball players taller than 200?

SELECT name FROM Player WHERE height >200;

SELECT name FROM Player WHERE height >=200;

SELECT name, height FROM Player WHERE height >200;

SELECT name, height FROM Player WHERE height <200;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

SELECT name, weight FROM Wrestler WHERE weight >170;

SELECT name, weight FROM Wrestler WHERE weight <= 170;

SELECT name, weight FROM Wrestler WHERE weight <170;

SELECT name, weight FROM Wrestler WHERE weight >=170;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which character always appears at the end of a SQL statement?

;

:

,

.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these statements will show all wrestlers sorted from the heaviest to the lightest?

SELECT * FROM Wrestler WHERE weight <170;

SELECT * FROM Wrestler WHERE weight >170;

SELECT * FROM Wrestler ORDER BY weight ASC;

SELECT * FROM Wrestler ORDER BY weight DESC;

Access all questions and much more by creating a free account

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?