Blog

Click the link below to begin the Midterm exam. The exam will open in a new browser tab and may take a minute or two to load. Be sure to answer all question and click “score exam” after the last question. You are not finished until you see a score. Midterm Exam

___________________, provides computer processing, memory, and storage media, as if the customer were renting a computer. Ex: Elastic Compute Cloud, or EC2, from Amazon Web Services offers infrastructure-as-a-service. 

Example: The database records the current project assignments for each employee. Updates are made right away when assignments change. The database does not retain prior assignments.  What is the data characteristic?

Can virtual machines running on the same computer contain different operating systems?

A complex type _____.

Which component of a query processor detects a missing semicolon at the end of an SQL statement?

Which component of a query processor determines that a query was recently executed?

Operational data changes _____, while analytic data is updated _____.

A primary key of a _____ is the composite of the foreign keys that reference a _____.

A ____ table contains numeric data used to measure business performance, such as sales revenue or number of employees. Each row in a ____ table consists of numeric fact columns and foreign keys that reference dimension tables.