CTS-115 - Part 2 Exam Review - Chapters 5 & 6

A _____ is a simple database program whose records have no relationship to one another.

• a user view

• schema

• relational system

• flat file

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

• data dictionary

• data mart

• data model

• data mine

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

• schema

• data definition language

• data manipulation language

• data dictionary

After entering data into a relational database, users can make all of the following basic data manipulations except:

• organizing

• projecting

• selecting

• joining

At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in ___________.

• data stewardship

• data management

• data lifecycle management

• database administration

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database.​ In terms of the characteristics of big data, Haley is dealing with ________.

• variety

• volume

• velocity

• veracity

You would use Query by Example, if _____.

• wish teach SQL with examples

• you build a query from an example

• you wish to use a visual approach to query building

• you use a template for reports

To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties?

• atomicity

• isolation

• currency

• durability

Which of the following statements is true of a database?

• It is accessed primarily for use by an organization's database administrator and data administrator.

• It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.

• It helps companies analyze information to open new market opportunities.

• It is a collection of unstructured data.

Suppose a new tech startup wants to define the data model. They would then ____.

• create the entity-relationship model

• collect and cleanse the data

• define user access privileges

• acquire a new database management system