Programming - Functions and SQL

Programming - Functions and SQL

8th - 10th Grade

30 Qs

quiz-placeholder

Similar activities

Sistem Komputer

Sistem Komputer

8th Grade

25 Qs

Pangkalan Data 2

Pangkalan Data 2

8th - 12th Grade

25 Qs

mata pelajaran plbj bab 15 kelas 3

mata pelajaran plbj bab 15 kelas 3

9th - 12th Grade

25 Qs

Journey Inside

Journey Inside

9th - 11th Grade

25 Qs

Introducción a las Presentaciones Digitales

Introducción a las Presentaciones Digitales

7th - 10th Grade

25 Qs

latihan sketchup #1

latihan sketchup #1

9th Grade

25 Qs

PTS GENAP

PTS GENAP

10th Grade

29 Qs

Fundamentos de Programación

Fundamentos de Programación

9th Grade

25 Qs

Programming - Functions and SQL

Programming - Functions and SQL

Assessment

Quiz

Computers

8th - 10th Grade

Practice Problem

Hard

Created by

Sean Johnson

Used 7+ times

FREE Resource

AI

Enhance your content in a minute

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

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of  *?

Selects ALL fields from the table
Selects only the first field in the table
Selects the last field in the table
Shows only the first row in the table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

With SQL, how do you select all the columns from a table named "Persons"?

 SELECT [all] FROM Persons
 SELECT *.Persons
 SELECT * FROM Persons
 SELECT Persons

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which query would return the fields Name and Form?

SELECT Name, Set FROM Pupils

SELECT Name, Group FROM Pupils

SELECT Name, Form FROM Pupils

SELECT Name, Gender FROM Pupils

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Return only the customers who have ER anywhere in their last name. 

last_name LIKE "%er%"
last_name = "%er"
last_name = "%er%"
last_name LIKE "%er"

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a function?

A section of code that will return a value

A section of code that will return nothing

A section of code that will return a command

None of the above

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a subroutine?

Function

Procedure

Parameter

Functions and Procedures

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

What will print?

nothing
5
6
an error message

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?