No student devices needed. Know more
33 questions
$789.00 is an example of which data type
Text
Currency
Boolean
Decimal
What is a primary key?
A field
A record
Two fields
A unique reference
Which field is the best fit to be a primary key?
FilmName
FilmID
AverageRating
Director
A field is...?
A specific piece of information in a database.
A category of data in a database, eg First Name or Date of Birth.
A large, open area usually covered in grass.
A box in a database.
A computer based database is a system that makes it easier to store, search through and display data.
True
False
Which is not an advantage for using computer based databases?
Can easily sort data into order e.g. alphabetic
Can easily make back-up copies
If there is a power-cut, you can’t use it
Can import or export data to/from other packages
When looking at a database how can you easily spot fields and records?
Fields are the rows of the database and records are the headings.
Fields are the headings of a database and records are the rows.
What is a File?
A file is all of the field types stored together.
A file is all of the records stored together.
A file is any piece of database information.
A file is usually made of cardboard and keeps papers tidy.
What is a 'database'?
A database is a collection of data or information which is stored in a logical and structured way.
A database is a place where all of the data in the world is stored.
A database is something that does not store data.
A database is a collection of data but not information.
Computer databases can store huge amounts of data without taking up any space in the real world.
True
False
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
Which of the following is an example of a field?
347
ChannelType
351, Nature, Documentary, Bling, False
The HD field is using the data type Boolean
True
False
What is the correct data type:
17th January
Text
Currency
Date / Time
number
Yes / No
What is the correct data type:
2008
Text
Currency
Date / Time
number
Yes / No
What is the correct data type:
£1.25
Text
Currency
Date / Time
number
Yes / No
What am I? I am a way of searching for data or information in a database.
Table
Record
Query
Field
Which of the following is not a characteristic of a relational database?
Tables are linked by relationships.
Data is stored in flat files.
It supports complex queries.
Reduces data redundancy.
What does 'Normalization' mean in the context of database design?
Converting the database to a normal form to reduce redundancy.
Ensuring the database is backed up regularly.
Adjusting the database to support more users.
Expanding the database size.
Which data type would be best for storing an email address?
Text
Number
Date/Time
Boolean
Match the following
foreign key | unique identifier | ||
secondary key | indexing and narrowing down a search | ||
primary key | a linked primary key in another table |
Data must be atomic
Each column should contain only one value
No repeating groups of data
No partial dependencies
Each non-key column should depend on the entire primary key
Every column is dependent on the primary key
Must already be in 1NF
Must already be in 2NF
Has a primary key
Explore all questions with a free account