Exam 5: It Architectures

The primary challenge of a distributed database is:

_______________ is the most commonly used database application for the PC.

A record represents a collection of _______________ that describe an entity.

A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.

According to the text,YouTube is an excellent example of _______________.

In all information systems,data resources must be organized and structured in some logical manner,so that they can be:

Entity Relationship Diagrams are _______________ of the various files and their relationships within a database system.

The _______________ model is the most widely used database structure today.

In a traditional file processing approach,each business application is designed to use one or more specialized data files containing only specific types of data records.

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?

In the relational database model,data are viewed as _______________.

In a _______________ database structure,all of the relationships among records are one-to-many,because each data element is related to only one element above it.

A website stores hyperlinked pages of multimedia (text,graphics,photographs,video,and audio)in a _______________ database.

What type of database are employees using when they access online data banks,whether those data banks are free or paid for through subscriptions?

A database of data definitions and specifications is called a metadata repository,or a _______________.

Database management packages based on the relational model can link data elements from various tables to provide information to users.

According to the Real World Case,a well-run data center with reduced complexity _______________.

Early mainframe DBMS packages used the _______________ structure,in which all records are dependent and arranged in multilevel structures,consisting of one root record and any number of subordinate levels.

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

One drawback to the database duplication process is that no changes can ever be made to any database other than the master.Otherwise,local changes will be overwritten during the duplication process.