Search Header Logo

Y10 - SQL Python Quiz

Authored by Samuel Geerling

Information Technology (IT)

10th Grade

Used 2+ times

Y10 - SQL Python Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

14 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A primary key is...

A field that uniquely identifies a record in a table

A record that uniquely identifies a field in a table

A field that links to another table

The most important field in the database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table in a database can be described as...

A complete set of records on a range of different topics

A complete set of primary keys

A complete set of records on the same topic

A nice place to sit and eat your dinner

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A field in a database can be described as...

A single type of data from a database

A record in a table

A collection of tables in a database

A nice place to play football

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A foreign key in a database can be described as...

A linking field from another database

A field that uses a different programming language

A field that can not communicate with the rest of the database

A linking field from another table

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Data redundancy in a database can be described as...

Evaluate responses using AI:

OFF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement will select all from the world table where name equals France?

SELECT France FROM world WHERE name = France

SELECT ALL FROM world WHERE name = France

SELECT * FROM world WHERE name = France

SELECT * FROM world where name == France

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which line of code does not contain an error?

INSERT INTO students VALUES 47, 'James', 'Moff',14, 'Male', '9R')

INSERT INTO students VALUES(47, 'James', 'Moff',14, 'Male', '9R')

INSERT INTO students VALUES(47 'James' 'Moff' 14 'Male' '9R')

INSERT students VALUES(47, 'James', 'Moff',14, 'Male', '9R')

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?