Have an account?
Skip to Content
Build your own quiz
Suggestions for you
22 questions
Show Answers
See Preview
- 1. Multiple ChoiceA scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?SQL UPDATE commandFormSQL SELECT QuerySort
- 2. Multiple ChoiceWhat data type would be used to store the following item code: 0024TextIntegerRealBoolean
- 3. Multiple Choice
In a TABLE, a column is known as a...
Record
Field
Row
Data
- 4. Multiple Choice
In a TABLE, a row is known as a...
Information
Column
Data
Record
- 5. Multiple Choice
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
- 6. Multiple Choice
In a database, data is stored in
Queries
Forms
Reports
Tables
- 7. Multiple Choice
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
- 8. Multiple Choice
What is a query?
Table
Question
Spreadsheet
Report
- 9. Multiple Choice
Which of these holds lots of data?
Record
Field
Table
Drawing
- 10. Multiple ChoiceText/String, Integer, Real/Float, Boolean and Date/Time are all examples of...Data TypesFiltersSortsValidations
- 11. Multiple ChoiceA data type used for storing numbers with a fractional part e.g. 3.142IntegerBooleanReal / FloatString
- 12. Multiple ChoiceA data type that can only hold 2 values e.g. Yes/No or True/False.BooleanIntegerRealString
- 13. Multiple Choice
Which of the following is an example of a record?
347
ChannelType
351, Nature, Documentary, Bling, False
- 14. Multiple Choice
Which data type would be most suitable for Length?
Integer
Float/Double
Boolean
String
- 15. Multiple Choice
Which of the following is an example of a field?
TimesPlayed
004
Holidays
- 16. Multiple Choice
Each item from this list is classified as...
Name, Birthdate, Street, County , PostCode
Table
Record
Field
- 17. Multiple ChoiceWhat is a relationship?Two relational databases share a fieldWhen a database has two matching primary keysWhen two people have the same surnameWhen two or more people have the same surname
- 18. Multiple ChoiceWhich of these could be a primary key?Centre numberSurnameTeacher nameStudents addresses
- 19. Multiple ChoiceWhich of these is an advantage of the flat-field database?It is cheapIt is flexibleIt only shows relevant informationIt is easier to find the information you want
- 20. Multiple ChoiceWhich of these is an advantage of relational databases?Only relevant data is displayedIt is cheaperIt is fasterData may be displayed multiple times so it is harder to miss
- 21. Multiple ChoiceHow many records are in this database?851012
- 22. Multiple ChoiceWhat is the primary key in this database?Emp_IdLast NameGenderTitle
- Answer choicesTagsAnswer choicesTags