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

List and describe the features of data in a data warehouse in contrast to data in a database.

Metadata is extraneous data generated from an SQL join command.

Although a database can consist of only a single file,it is usually a group of files.

____________________ is a standard fourth-generation query language used by many DBMS packages,such as Oracle 11g and Microsoft SQL Server.

Describe how data stored in a relational model is retrieved from tables.

The ____ approach to a distributed DBMS has each site store a copy of the data in the organization's database.

We use the ____ operator when all conditions are required to be met.

Describe the features and benefits of an object-oriented database.

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

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

____ gives users subtotals of various categories.

The structure and organization of data in a database is called a data ____.

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

What is the physical view of a database?

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

A(n)____________________ is the structure and organization of data,which involves fields,records,and files.

Redundant data is eliminated by a process called normalization.

In a data warehouse,____ means collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

The database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

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.