Module 1: Data Concepts and Environments - Test Your Knowledge

What is the language that is used for querying in relational databases?

What elements of a database are necessary for the tables to establish relationships?

A database architect creates a design in which a table has a primary key and associated fields. This is an example of what type of design theory?

What type of table stores information that is categorical for the use of reporting?

What are two common schemas that are used to relate data in a data warehouse?

Which type of slowly changing dimension is used when a new record is added to account for a change to dimension data?

What are the two highest-level types of data for a field?

Would data that is stored in a relational database be considered structured or unstructured data?

Video, audio, and images are all examples of what type of data?

Which markup language supports the transfer of data between systems and is a child of SGML?