S3 Databases Knowledge Check

What is the purpose of a database?

• To store information

• To store information in an organised way

• To look at information on a topic

• To have the information in all one place

What is the definition of a field?

• The whole table of information

• A little piece of information like Pupil Name or Hair Colour

• A collection of information on one object, like a person or a movie

• Big green thing

What makes a field a primary key?

• Each value is a number

• Each value is a combination of letters and numbers

• Each value is unique to each record

• Each value is either Yes or No

What Microsoft program can you use to create a new database?

• Excel

• Word

• Powerpoint

• Access

Which of the following is not a database data type?

• Text

• Date/Time

• Number

• Character

What data type would be used for the PostID field?

• Number

• Text

• Boolean

• Date

Which of the following is the correct order for a SQL query?

• SELECT FROM WHERE

• FROM SELECT WHERE

• WHERE SELECT FROM

• SELECT WHERE FROM

What is the purpose of SELECT in an SQL statement?

• Selects the answers from the table

• Selects the correct records

• Selects the fields we want to display

• Selects the table

What is the purpose of FROM in an SQL statement?

• Indicates the table we want the information from

• Indicates the fields we want from the table

• Indicates the records from the table

• Indicates we want to find some information

What is the purpose of WHERE in an SQL statement?

• The search condition, what we're searching for

• Where the information is correct

• What fields we want to show

• Which table we are getting the information from