Exam 14: Databases and Database Management Systems

Most databases created today do not use the hierarchical or network models;these models are generally used with legacy systems that are still operational and must be maintained.

At the lowest level,words are entered into database fields/columns,which hold single pieces of data in the database,such as product names or quantities.

Web databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages change based on the user’s input.

Objects stored in an OODBMS can be retrieved using queries,such as with a(n)object query language (OQL)-an object-oriented version of SQL.

____ are made up of related records.

As part of its disaster-recovery plan,some firms maintain a(n)hot site-an alternate location equipped with identical hardware and software that can be used to resume operations quickly in case of a major disaster.

In some systems,data integrity is enforced on a per transaction basis.

If a field needs to store decimal places,the Long Integer field size can be used.

After all the tables in a database application have been created and their primary keys designated,the tables can be related to one another via their primary key so that a primary key for one table can be used to extract data from other tables as needed.

With ____,data is stored in single multidimensional database structures (sometimes called data cubes).

With indexed organization,a(n)____________________ is used to keep track of where data is stored.

Individual database tables are often referred to as ____.

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

A record is also called a ____.

Data definition involves describing the properties of the data that go into each database table,specifically the ____ that make up the database.

Case 14-2 The JL Group is a political think tank that is incorporating new media into their analyses. -The JL Group has gathered data on voting habits.In order to make sure that respondents cannot claim to have voted in more elections than is possible given their age,____ rules can be assigned to the database tables.

Normalization is usually viewed as a multistep process,from first normal form (1NF)to usually fifth normal form (5NF).

In determining the location where specific data is to be stored in a(n)centralized DBMS,factors such as communications cost,response time,storage cost,and security are key considerations.

Upgrading the database software and installing patches as needed is a database ____________________ activity.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.