Have an account?
Skip to Content
Build your own quiz
15 questions
Show Answers
See Preview
- 1. Multiple ChoiceWhat is a database?A piece of software to do calculationsA device to load information onto the computer.A structured collection of informationA calculator
- 2. 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
- 3. Multiple ChoiceA sports club needs to store information about each member. The individual information about each member is called a:FieldFileTableRecord
- 4. Multiple ChoiceOne of the members of the Sports Club has decided to resign. What would the secretary do with the record for that member on the database?Amend the recordDelete the fieldDelete the recordDelete the file
- 5. Multiple ChoiceThe Sports Club has had an Open Day and has gained a new member. How will they add their details to the database?Add another fieldAmend a recordAdd a new recordDelete a record
- 6. Multiple ChoiceThe whole database is called:The fileThe fieldThe recordThe table
- 7. Multiple ChoiceOne specific piece of information about a person or thing is called:FieldFileRecordTable
- 8. 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
- 9. Multiple ChoiceA gym has a database with all their members they want to include email addresses in the database, what will they do?Add a recordAdd a fieldEdit a recordDelete a field
- 10. Multiple ChoiceA health club wants to find all the members who use the club 3 days or more a week. What will they put in the query in the 'days' SQL query criteria?>3<3<=3>=3
- 11. Multiple ChoiceThe health club stores the ages of its members. What validation check would be used on the age field?Restricted choiceLengthPresenceRange
- 12. Multiple ChoiceWhat data type would be used to store the following item code: 0024TextIntegerRealBoolean
- 13. Multiple ChoiceThe school wants to sort the data by staff Surname. How will they sort it?Ascending orderDescending order
- 14. Multiple ChoiceA film club stores details of all the films it shows. One of the fields is Genre (sample data: Action, Horror, Family, Romance etc). What validation would be most suitable for this field?LengthPresenceRangeRestricted Choice
- 15. Multiple ChoiceIKEA stores details of it's stock on a relational database. Along with a unique stock code, all items are stored in coded aisles eg. BLU24, ORA23, YEL49 etc. What type of validation would be used on this aisle code?PresenceLengthRangeField
- Answer choicesTagsAnswer choicesTags