Exam 5: It Architectures

Database administrators and database design analysts work with end users and systems analysts to do all of the following except:

Data models represent _______________ views of the data and relationships of the database.

Multidimensional databases have become the least popular structure for analytical databases that support online analytical process (OLAP)applications,in which fast answers to complex queries are expected.

In large organizations,a database is usually controlled by a DBA,which stands for:

_______________ database design takes a physical view of the data that describes how data are to be physically stored and accessed on the storage devices of a computer system.

A database with a network data structure can easily handle a many-to-many data relationship,whereas a hierarchical model can not.

Database administrators and designers work with corporate and end user management to develop an _______________ model that defines the basic business process of the enterprise.

Object technology allows designers to do all of the following except:

The rise of open-source software has challenged the notion that those who invest in software development hold onto it for competitive advantage.

Files are frequently classified by the application for which they are primarily used,such as a payroll file or an inventory file.

In file processing systems,it was easy for data elements,such as stock numbers and customer addresses,to be defined differently by different end users and applications.

Many end users have trouble correctly phrasing database language search queries,so most end-user DBMS packages now offer _______________ methods.

Database development involves defining and organizing the _______________ of the data needed to build a database.

Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.

Which of the following is true of data in a data warehouse?

Data warehouses may be subdivided into _______________,which hold subsets of data from the warehouse that focus on specific aspects of a company,such as a department or a business process.

A _______________ represents a collection of attributes that describe a single instance of an entity.

A central source of data that have been cleaned,transformed,and cataloged so that they can be used for business analysis,market research,and decision support is called a _______________.

A group of related records is a data file,or a _______________.

DBMS packages play a major role in application development.