Exam 5: Data Resource Management

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

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

In the relational database model, all data elements within the database are viewed as being stored in the form of simple, two-dimensional tables, sometimes referred to as _______________.

In _______________, the data in a data warehouse are analyzed to reveal hidden patterns and trends in historical business activity.

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

Boolean logic deals with three logical operators:

Distributed databases require fewer resources when it comes to computing power and bandwidth.

The basic form of a SQL query is:

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs) and other database specialists.

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.

All the fields used to describe the attributes of an entity are grouped to form a(n) _______________.

In mainframe and server computer systems, the database management system controls the _______________ of the databases of computer-using organizations.

Variable-length records contain a variable number of fields with fixed field lengths.

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

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.

Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table. This is the _______________ operation.

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

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

Which database structure works effectively with complex data types, such as video clips, audio segments, and other subsets of Web pages, and is considered one of the key technologies of Web-based applications?

_______________ contain both a fixed number of fields and fixed field lengths.