NEW
Font size
WorksheetsS3 Databases Knowledge Check
Total questions: 15
Worksheet time: 8mins
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
What does this operator mean?
<=
More than or equal to
Less than
Less than or Equal to
Not equal to
Which SQL query will successfully display the post by @WillSmith from New York?
SELECT Username, PostID, LocationTag
FROM Posts
WHERE Username = "@WillSmith"
SELECT Username, PostID, LocationTag
FROM Posts
WHERE LocationTag = "New York"
SELECT Username, PostID, LocationTag
FROM Posts
WHERE Username = "@WillSmith" And LocationTag = "New York"
What is the purpose of a restricted choice validation?
Give the user a restricted list of options to choose from
Give the user only numbers to choose from
Give the user only text to choose from
Limit the amount of characters in the field
What is the purpose of a presence check validation?
To make sure the field is present
To make sure the field is not left blank
To make sure all the fields in the database are empty
To make sure all the fields have field names
What does SQL stand for?
Structure Query Language
Structured Queried Languages
Standard Query Lingo
Single Quandary Language
