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

What is structured query language (SQL)?

The ____ in a database model describes methods,calculations,and so forth that can be performed on data,such as updating and querying data.

Data in a data warehouse can be differentiated from data in a database in that the former ____.

In a relational model,when a primary key for one table appears in another table it is called a ____ key.

A data ____ stores definitions,such as data types for fields,default values,and validation rules for data in each field.

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

The ____ in a database model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

Business intelligence uses scorecards and query reports to support decision-making activities,whereas business analytics uses data mining tools and predictive modeling.

What is business analytics?

What are some of the sources of external data?

What is the data definition component of a DBMS?

In well-designed data-driven Web sites,changes are made to the HTML code.

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

A select operation pares down a table by eliminating columns according to certain criteria.

In large organizations,database design and management is handled by the database ____________________.

To begin designing a relational database,you must define the ____ structure by defining each table and the fields in it.

In a hierarchical data model,nodes with the same parents are called siblings.

What is a distributed database management system (DDBMS)?

____ uses multiple sources of information and provides multidimensional analysis.

What is a data-driven Web site?