L1 Database Terms .v2

What is big data?

• A small collection of data

• A collection of data that is easy to process

• A collection of data so large and complex that it is difficult to store and process using traditional database software

• A type of database management system

What is a common field in a database?

• A field that appears in only one table

• A field that appears in more than one table

• A field that is not used in any table

• A field that is used for calculations

What does data integrity refer to?

• The size of the data

• The speed of data processing

• The validity and accuracy of the data

• The cost of data storage

What is a flat-file database?

• A database that stores its contents in multiple tables

• A database that stores its contents in a single table

• A database that does not store any data

• A database that is used for images only

What is a database?

• A file that stores images

• A file that stores data in an organized fashion so information can be retrieved from it.

• A file that deletes data automatically

• A file that is used for music storage

What is a database management system (DBMS)?

• A program used to delete databases

• A program used to store, access, and manipulate database information

• A program used to create images

• A program used to play music

What is Microsoft Access?

• A type of spreadsheet software

• An end-user database management system used to create and manipulate small and uncomplicated databases

• A programming language used in databases

• A web browser

What does Open Database Connectivity (ODBC) allow us to do?

• Create images

• Use the MS Access interface tools to access the DBMS data

• Play music

• Edit videos

What is a query in the context of databases?

• A type of database

• Another word for a question so users can retrieve specific information

• A type of spreadsheet

• A programming language

What is a relational database?

• A database with only one table

• A database with multiple tables of information related through common fields

• A database that does not store any data

• A database used only for images