Database Essentials - Lesson 1

Front

Which of the following consists of multiple tables of information that are related through common fields?
Options: spreadsheet, text document, presentation, relational database

Back

relational database

Front

Which software would be the best choice to help with compiling student and teacher information for connecting teachers to students based on classes taken and home addresses? Options: spreadsheet, text document, presentation, relational database

Back

relational database

Front

You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?

Back

Databases remove the need for redundant data.

Front

Which tool allows a user to perform all of these tasks - collecting, editing and questioning data? Options: Pen and paper, Calculator, Text document, Database

Back

Database

Front

What feature of a database would improve the tracking process of survey results shared in different file types via email that are inconsistent and questionable?

Back

Data can be protected against accidental changes.

Front

What kinds of data types can be stored in relational databases?

Back

Images

Front

What attributes of your database define it as a "relational database"? Options: Multiple tables in a single query that are used together, Multiple fields in a single table that are joined to form relationships, Multiple tables containing related information for a single use, Multiple tables with common fields that are joined to form relationships

Back

Multiple tables with common fields that are joined to form relationships

Front

In a relational database, data types can:

Back

Consist of multiple data types, including text, numbers, graphics, sound clips and video.

Front

Which statement is true about the data types that can be used in relational databases? Options: Data types can only consist of text and numbers., Data types can consist of text, numbers and some graphic formats., Data can consist of any data types except for sound clips., Data can consist of multiple data types, including text, numbers, graphics, sound clips and video.

Back

Data can consist of multiple data types, including text, numbers, graphics, sound clips and video.

Front

What information would be the most helpful for Keisha to have in her database to help her with her tracking? Options: Name of Principal, School Address and Name of Teacher. Class Title, Room number and Name of Principal. School Address, Class title and Teacher's Email. Class dates, Class Title and Name of Teacher.

Back

Class dates, Class Title and Name of Teacher.