Database Assessment (S2)

What is a database?

• A database is a type of spreadsheet.
• A database is a type of computer virus.
• A database is a type of video game.
• A database is a structured collection of data.

What is a record?

• A row of data that contains information about a single entity or item.
• A type of computer virus
• A type of document storage
• A type of musical recording

Which data type is used to store letters or a mixture of letters, numbers and symbols?

• Text
• Date
• Boolean
• Number

What is the purpose of the Primary Key?

• To calculate the average value of a column
• To display the data in a user-friendly format
• To uniquely identify each record in a database table.
• To organize data in alphabetical order

What is meant by a simple sort?

• Mixing items randomly
• Arranging items in reverse order
• Arranging items in a specific order based on a single criterion or condition

• Selecting items based on multiple attributes

What is meant by a complex search?

• A search query that involves multiple criteria or parameters to find specific information
• A search query that is simple and straightforward
• A search query that returns no results
• A search query that only uses one keyword

Which of the following symbols/relational operators is used for 'greater than'?

• <=
• <
• ==
• >

Which of the following symbols/relational operators is used for 'less than or equal to'?

• <=
• <
• ==
• =>

What is a 'wildcard' search?

• A search that only looks for exact matches
• A search that ignores special characters
• A search that only looks for capitalized words
• A type of search that allows for the use of special characters to represent one or more characters in a search term

Which symbol is used for a wildcard search?

• *
• !
• ,
• %