Exam 3: Database Systems,Data Warehouses,and Data Marts

In well-designed data-driven Web sites,changes are made to the _____ code every time a Web site's data content changes.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

A database is a critical component of information systems because any type of analysis that is done is based on data available in the database.

Describe the fragmentation approach to setting up a distributed database management system.

Grouping objects along with their attributes and methods into a class is called _________.

The network model is similar to the hierarchical data model because records are organized in the same way.

Identify a true statement about a database.

What are the advantages of a database over a flat file system?

In a relational database model,a(n)_____ operation searches data in a table and retrieves records based on certain criteria.

A _________ is software for creating,storing,maintaining,and accessing database files.

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

In data warehouses,_____ is information about data-its content,quality,condition,origin,and other characteristics.

Describe the loading process used in data warehouses.

The _____ approach,used to set up a distributed database management system (DDBMS),combines fragmentation and replication.

What is business analytics?

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods that are called by sending a message to an object.

Identify the number of physical views of data for a database.

Which of the following is an example of a source for external data?

What is structured query language (SQL)?