Y7 Databases Test

Which of these is not an advantage of using an electronic database?

• Faster to find information
• Easy to move information - portable
• Could be hacked
• Can keep a back-up copy

Which of these is an advantage of a paper database?

• Easily damaged or lost
• Hard to update information
• Can share from one computer to another
• They are cheap to use

What is a flat file database?

• A database that's squashed like a pancake
• A database with only 1 table
• A database that doesn't contain much data
• A database with multiple tables that are linked together

Which description is correct for a record?

• All the information about one person or item 
• Used to print information from the database
• A method of searching the database for specific information
• A place where all records are stored

What filter has been applied in this table?

• Gender - Male
• Eyes - Blue
• Hair - Black
• Height - Ascending Order

Which 2 filters have been applied in this table?

• Eyes (Blue) & Real Name (Sort Ascending)
• Weight (Sort Descending) & Gender (Male)
• Superhero (Sort Descending) & Lives (Gotham City)
• Gender (Male) & Superhero (Sort Ascending)

What is the main purpose of sorting/filtering data?

• Makes it nicer to look at
• Makes it easier to input new data
• Helps to find specific information quickly
• Gives me something to do when I'm bored

Which description is correct for a query?

• Used to print information from the database
• A method of searching the database for specific information
• A place where all records are stored
• All the information about one person or item

In this query - what 2 pieces of criteria have been used?

• Gender (Male) Lives (Gotham City)
• Hair (Black) Gender (Male)
• Eyes (Blue) Lives (Gotham City)
• Eyes (Blue) Hair (Black)

What would you expect the results of this query to show?

• All the superheroes with black eyes and blue hair
• All the female superheroes with black hair
• All the male superheroes with blue eyes
• All the superheroes with blue eyes and black hair