SQL quizz

SQL quizz

Professional Development

13 Qs

quiz-placeholder

Similar activities

All About Me

All About Me

KG - Professional Development

10 Qs

ABAP I - 11 y 12° Clase en vivo: ABAP SQL II

ABAP I - 11 y 12° Clase en vivo: ABAP SQL II

Professional Development

10 Qs

snow3

snow3

Professional Development

13 Qs

HB-Greenwich

HB-Greenwich

Professional Development

10 Qs

Cold water level two 2

Cold water level two 2

Professional Development

16 Qs

AWS Big Data - Day 1

AWS Big Data - Day 1

Professional Development

11 Qs

Dog breed test

Dog breed test

6th Grade - Professional Development

11 Qs

BAnDS Tournament Round 3

BAnDS Tournament Round 3

University - Professional Development

10 Qs

SQL quizz

SQL quizz

Assessment

Quiz

Specialty

Professional Development

Easy

Created by

Mai Anh Nguyễn

Used 3+ times

FREE Resource

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

What is missing in this code?

SELECT * FROM WHERE genre = 'action' ORDER BY year ARC;

Table name

Capitalize action

Missing an AND

None of these

2.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

Match the following SQL term with a description - ORDER BY

The table used in the query

The criteria that must be met

The field and order used to sort the results

The fields to display

3.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

When examining a row in a table, we refer to it as a...

result

result number

row number

record

4.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

How do we select all rows for the "Designer" table?

SELECT Designer.*

SELECT [All] FROM Designer

SELECT FROM Designer

SELECT * FROM Designer

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

What does the SQL term 'JOIN' refer to?

Combining rows from two or more tables based on a related column between them

Sorting the results in ascending order

Filtering rows based on a condition

Grouping rows with the same value

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which SQL statement is used to delete a table?

REMOVE TABLE table_name;

DROP TABLE table_name;

DELETE TABLE table_name;

ERASE TABLE table_name;

7.

MULTIPLE CHOICE QUESTION

5 sec • 1 pt

What is the purpose of the SQL statement 'GROUP BY'?

To filter rows based on a condition

To sort the results in descending order

To group rows that have the same values into summary rows

To update existing records in a table

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?