DBMS Assessment Exam

What is a key characteristic of knowledge?

"new" knowledge can be derived from "old" knowledge

What type of relationship is expressed with the phrase "Employee manages Store"?

1:1

What type of relationship is expressed with the phrase "Painter paints Painting"?

1:M

How many users does a workgroup database usually support?

50

The ____ manages interaction between the end user and the database.

DBMS

The ____ receives all application requests and translates them into the complex operations required to fulfill requests.

DBMS

____ are considered database architects.

Database designers

The most widely used conceptual model is the ____ model.

ER

____ are the people who use application programs to run the organization's daily operations.

End users

Date attributes contain calendar dates stored in a special format known as the ____ date format.

Julian

What type of relationship is expressed with the phrase "Student takes Class"?

M:N

Which of the following products do not provide an enterprise database?

MS Access

A field that consists of values on which you can perform arithmetic operations is a ____ type field.

Numeric

Data are classified according to their format and function and consist of ____.

Numeric, Character, Date, and Logical

____ are the instructions and rules that govern the design and use of the database system.

Procedures

____ deals with fixing the database after a failure such as a disk or power failure.

Recovery

From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ____.

SQL engine

Data ____ exists when the same data are stored unnecessarily at different places.

Structural

____ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Structural

____ is the de facto query language and data access standard supported by the majority of DBMS vendors.

Structured Query Language

For most relational database software, the query language is ____.

Structured Query Language (SQL)

What is the name for the most current version of class diagram notation?

Unified Modeling Language

A way of classifying data models is by degree of ____.

abstraction

The object-oriented model ____.

adds semantic content

The network database models have ____.

an owner/member relationship that promotes database integrity

A data ____ develops when all of the required changes in the redundant data are not made successfully.

anomaly

A(n) ____ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.

blueprint

A(n) ____ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.

business rule

Which data model was developed most recently?

column store

A relation is a matrix consisting of a series of row and ____.

columns

A primary key that consists of more than one attribute is called a ____ key.

composite

A(n) ____ model is independent of both hardware and software.

conceptual

The ____ model presents a global view of the entire database.

conceptual

The basic building blocks of all data models are entities, attributes, relationships, and ____.

constraints

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ____.

create a new query

The logical view of the relational database is facilitated by the ____.

creation of data relationships based on a construct known as a table

A raw fact such as a telephone number is known as ____.

data

Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ____.

data dependence

Where does the DBMS store the definitions of data elements and their relationships?

data dictionary

The ____ is a specialized database that stores data in a format optimized for decision support.

data warehouse

The design of a ____ database recognizes the use of historical and aggregated data.

data warehouse

A ____ system is composed of software, hardware, data, procedures and people.

database

The term ____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

database system

A single-user database that runs on a personal computer is called a(n) ____ database.

desktop

The key's role is based on a concept known as ____.

determination

A database that supports data distributed across several different sites is called a(n) ____ database.

distributed

One of the advantages of a relational data model is ____.

easier database design

A CUSTOMER ____ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.

entity

As a general rule, a noun in a business rule will translate into a(n) ____ in the model.

entity

Which model represents the end users' view of the data environment?

external

A specific representation of an external view is known as a(n) ____.

external schema

Where was a traditional file system normally stored?

file cabinet

Raw data must be properly ____ for storage, processing, and presentation.

formatted

Traditionally, database designers relied on ____ to help them develop a good design.

good judgment

Classes are organized as a class ____.

hierarchy

In the context of a database table, the statement "A determines B" indicates that ____.

if you know the value of attribute A you can look up the value of attribute B

Database models can be grouped into two categories: conceptual models and ____ models.

implementation

Data ____ exists when the same data are stored unnecessarily at different places.

inconsistent redundant data

Data ____ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

independence

Accurate, relevant, and timely ____ is the key to good decision making.

information

Processed data, or ____, can be used as the foundation for decision making.

information

Each row in the relational table is known as an entity ____.

instance

Wider access to well-managed data promotes a(n) ____ view of the organization's operations and a clearer view of the big picture.

integrated

Data ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."

integrity

A(n) ____ model maps the conceptual model to the DBMS.

internal

What is the fastest and most direct source of business rules?

interviews with end users

Human beings view data according to its ____ data format.

logical

What is the name for data about data?

metadata

In the OO data model, a class ____ represents a real-world action such as finding a selected PERSON's name.

method

Data models were developed to ____.

model real-world objects or events

What model requires the most detail in its internal model?

network

A(n) ____ allows the user to specify what must be done without specifying how it must be done.

nonprocedural language

In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ____.

object

Which data model contains the most semantics?

object-oriented

The hierarchical database model depicts a set of ____ relationships.

one-to-many

Which model operates at the lowest level of abstraction?

physical

When you can change the physical model without affecting the internal model, you have ____.

physical independence

Each table must have a ____ key.

primary

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ____.

query language

What is the name for an answer to a query that the DBMS sends back to the application?

query result set

The word ____ indicates that the facts have not yet been processed to reveal their meaning.

raw

All fields for a specific entity can be grouped together as a ____.

record

How is an entity represented in an ERD?

rectangle

A superkey is any key that uniquely identifies each ____.

row

Within the network model, the ____ is the conceptual organization of the entire database as viewed by the database administrator.

schema

A ____ is the equivalent of a file system's record type.

segment

The hierarchical model depicts a(n) ____ of one-to-many relationships.

set

A record consists of a ____.

set of one or more fields

Database management systems, operating systems, applications and utilities are all examples of ____.

software

An ad hoc query is a ____.

spur-of-the-moment question

Another word for the term "relation" is ____.

table

A relational database is a collection of ____.

tables

What modern development gave the use of complex objects a boost?

the Internet

Data processing (DP) specialists are in existence because of ____.

the need to track data and produce required reports

Data management is a discipline that focuses on ____.

the proper generation, storage, and retrieval of data

What is a benefit of using a DBMS?

they help create an environment for end users to have access to more data

Another name for a production database is a ____ database.

transactional

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ____.

tuning

Each table is perceived as a ____.

two-dimensional structure

XML databases have emerged to address the need to manage ____ data within the native XML format.

unstructured