Have an account?
Skip to Content
15 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.What is a database?A piece of software to do calculationsA device to load information onto the computer.A structured collection of informationA calculator
- Multiple ChoicePlease save your changes before editing any questions.Which 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
- Multiple ChoicePlease save your changes before editing any questions.A sports club needs to store information about each member. The individual information about each member is called a:FieldFileTableRecord
- Multiple ChoicePlease save your changes before editing any questions.One 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
- Multiple ChoicePlease save your changes before editing any questions.The 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
- Multiple ChoicePlease save your changes before editing any questions.The whole database is called:The fileThe fieldThe recordThe table
- Multiple ChoicePlease save your changes before editing any questions.One specific piece of information about a person or thing is called:FieldFileRecordTable
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.The health club stores the ages of its members. What validation check would be used on the age field?Restricted choiceLengthPresenceRange
- Multiple ChoicePlease save your changes before editing any questions.What data type would be used to store the following item code: 0024TextIntegerRealBoolean
- Multiple ChoicePlease save your changes before editing any questions.The school wants to sort the data by staff Surname. How will they sort it?Ascending orderDescending order
- Multiple ChoicePlease save your changes before editing any questions.A 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
- Multiple ChoicePlease save your changes before editing any questions.IKEA 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