Have an account?
Skip to Content
Build your own quiz
Suggestions for you
.png)
33 questions
Show Answers
See Preview
- 1. Multiple Choice
$789.00 is an example of which data type
Text
Currency
Boolean
Decimal
- 2. Multiple Choice
What is a primary key?
A field
A record
Two fields
A unique reference
- 3. Multiple Choice
Which field is the best fit to be a primary key?
FilmName
FilmID
AverageRating
Director
- 4. Multiple ChoiceWhat is used to present the relationship between entities in a database?ER DiagramReferential integrityPrimary KeyForeign Key
- 5. Multiple ChoiceWhich of the following is a category of object, person, event or a thing of interest to an organisation?Flat FileEntityAttributePrimary key
- 6. Multiple ChoiceWhich type of relationship best describes the following?
Head teacher who runs a SchoolOne to oneMany to manyOne to many - 7. Multiple ChoiceWhich of these is a one to many relationship?Customer and orderMum and childrenPrinter model and cartridgeAll of the above
- 8. Multiple ChoiceFilm title is a suitable Primary key, true or false?TrueFalse
- 9. Multiple ChoiceFlat file database is a database where tables are linked, true or false?TrueFalse
- 10. Multiple Choice
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.
- 11. Multiple Choice
A computer based database is a system that makes it easier to store, search through and display data.
True
False
- 12. Multiple Choice
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
- 13. Multiple Choice
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.
- 14. Multiple Choice
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.
- 15. Multiple Choice
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.
- 16. Multiple Choice
Computer databases can store huge amounts of data without taking up any space in the real world.
True
False
- 17. Multiple ChoiceWhich of the following describes a relational database?AccessA database that has a tableThere are two or more tables that are linked using the primary keysThere are more than one table that have duplicate data
- 18. Multiple ChoiceA sports club needs to store information about each member. The individual information about each member is called a:FieldFileTableRecord
- 19. Multiple ChoiceWhich of these could be a primary key?Centre numberSurnameTeacher nameStudents addresses
- 20. Multiple ChoiceHow many records are in this database?851012
- 21. Multiple ChoiceWhat is the primary key in this database?Emp_IdLast NameGenderTitle
- 22. Multiple Choice
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
- 23. Multiple Choice
Which of the following is an example of a field?
347
ChannelType
351, Nature, Documentary, Bling, False
- 24. Multiple Choice
The HD field is using the data type Boolean
True
False
- 25. Multiple Choice
What is the correct data type:
17th January
Text
Currency
Date / Time
number
Yes / No
- 26. Multiple Choice
What is the correct data type:
2008
Text
Currency
Date / Time
number
Yes / No
- 27. Multiple Choice
What is the correct data type:
£1.25
Text
Currency
Date / Time
number
Yes / No
- 28. Multiple Choice
What am I? I am a way of searching for data or information in a database.
Table
Record
Query
Field
- 29. Multiple Choice
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.
- 30. Multiple Choice
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.
- 31. Multiple Choice
Which data type would be best for storing an email address?
Text
Number
Date/Time
Boolean
- 32. Match
Match the following
primary key
unique identifier
secondary key
indexing and narrowing down a search
foreign key
a linked primary key in another table
- 33. Categorize
Organize these options into the right categories (a) 1st normal form , (b) 2nd normal form , (c) 3rd normal formData 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
- Answer choicesTagsAnswer choicesTags