ICT Database Essentials Quiz

What is a database?

• A type of computer program

• A collection of random data

• A file that stores data in an organized fashion

• A list of files on a computer

What is a simple way to create a flat file database?

• iPod playlist

• Spreadsheet

• Cells

• Rows

What is a disadvantage of spreadsheets?

• Have limited sorting and querying capabilities

• Changes to data are complete immediately

• Require that you enter the same information in multiple places

• Contain an unlimited number of records

What is data integrity?

• The speed of accessing the data

• The size of the data

• The accuracy of the data (garbage in, garbage out)

• The complexity of the data

What is a relational database?

• Consists of multiple tables of information connected through common fields

• A database with no limits on data size

• A database with no connections between tables

• A database with only one table

What is a disadvantage of relational databases?

• They are easier to use than spreadsheets

• They have limited data storage capacity

• They have lower hardware and software requirements

• They are more complex and harder to design and use than spreadsheets

What is big data?

• Data that is organized in a simple manner

• Huge volumes of data that are too huge for regular database programs

• Data that is easy to analyze

• Small and related data

What is Structured Query Language (SQL) used for?

• Managing hardware components

• Analyzing big data

• Creating graphical designs

• Querying and managing databases

What is Open Database Connectivity (ODBC)?

• Open standard application programming interface (API)

• A type of computer virus

• A programming language

• A database management system

Creating tables helps to:____

• Identify duplicate data

• Make it east to see

• Give examples of data

• Make it relatable