Ch. 1 & Ch. 2 Flashcards by Tony Cazarez

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

a. raw data
b. information
c. queries
d. DP

b. information

How well did you know this?

Not at all

Perfectly

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

a. processing
b. data
c. information
d. relationships

c. information

How well did you know this?

Not at all

Perfectly

What is the name for data about data?

a. metadata
b. raw data
c. superdata
d. unique data

a. metadata

How well did you know this?

Not at all

Perfectly

Data management is a discipline that focuses on ________.

a. the management of end users
b. the help items to be used by end users
c. the proper generation, storage, and retrieval of data
d. the proper generation, storage, and retrieval of information

c. the proper generation, storage, and retrieval of data

How well did you know this?

Not at all

Perfectly

What is a benefit of using a DBMS?

a. It helps create an environment for end users to have access to more data.
b. It provides full security to data using private/public key encryption.
c. It provides seamless Internet access to database data.
d. It creates automatic backups.

a. It helps create an environment for end users to have access to more data.

How well did you know this?

Not at all

Perfectly

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

a. DBMS
b. workgroup
c. DB
d. query

a. DBMS

How well did you know this?

Not at all

Perfectly

An ad hoc query is a ________. a. spur of the moment question b. question that will not return any results

c. pre- scheduled question
d. pre-planned question

a. spur of the moment question

How well did you know this?

Not at all

Perfectly

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

a. query result set
b. DBMS result
c. data result
d. question result

a. query result set

How well did you know this?

Not at all

Perfectly

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

b. desktop
c. enterprise
d. distributed

b. desktop

How well did you know this?

Not at all

Perfectly

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

a. workgroup
b. enterprise
c. desktop
d. distributed

d. distributed

How well did you know this?

Not at all

Perfectly

A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

a. data warehouse
b. workgroup database
c. production database
d. distributed database

a. data warehouse

How well did you know this?

Not at all

Perfectly

Another name for a production database is a ________ database.

a. development
b. transactional
c. data mining
d. warehouse

b. transactional

How well did you know this?

Not at all

Perfectly

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

a. create a new query
b. utilize the Database Wizard c. create a new table
d. create a new form

a. create a new query

How well did you know this?

Not at all

Perfectly

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

a. MS Access
b. IBM DB2
c. MS SQL Server
d. Oracle RDBMS

a. MS Access

How well did you know this?

Not at all

Perfectly

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

b. data warehouse
c. multiuser
d. single-user

b. data warehouse

How well did you know this?

Not at all

Perfectly

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

a. the increase in the number of computers
b. the need to speed up processing of data
c. the need to track data and produce required reports
d. the advent of database management systems

c. the need to track data and produce required reports

How well did you know this?

Not at all

Perfectly

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

a. database
b. computer
c. software
d. file

a. database

How well did you know this?

Not at all

Perfectly

A record consists of a ________.

a. collection of related records b. set of one or more fields
c. group of files
d. character

b. set of one or more fields

How well did you know this?

Not at all

Perfectly

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

a. record
b. file
c. database
d. field

a. record

How well did you know this?

Not at all

Perfectly

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

a. object-oriented language
b. script
c. procedural language
d. nonprocedural language

d. nonprocedural language

How well did you know this?

Not at all

Perfectly

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.

a. mining
b. integrity
c. inconsistency
d. independence

d. independence

How well did you know this?

Not at all

Perfectly

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 ________.

a. data dependence
b. logical data format
c. data independence
d. physical data format

a. data dependence

How well did you know this?

Not at all

Perfectly

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

a. Logical
b. Structural
c. Physical
d. Fragmentation

b. Structural

How well did you know this?

Not at all

Perfectly

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

a. dependency
b. fragmentation
c. redundancy
d. inconsistency

c. redundancy

How well did you know this?

Not at all

Perfectly

A data ________ develops when all of the required changes in the redundant data are not made successfully. a. anomaly b. redundancy c. dependence d. inconsistency

a. anomaly

________ are the people who use application programs to run the organization's daily operations. a. End users b. Data practitioners c. Database programmers d. Managers

a. End users

________ are considered database architects. a. Systems administrators b. Database designers c. Systems analysts and programmers d. Database administrators

b. Database designers

Where does the DBMS store the definitions of data elements and their relationships? a. data file b. data dictionary c. data map d. index

b. data dictionary

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________. a. development b. upgrades c. enhancements d. tuning

d. tuning

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) ________. a. access control b. security system c. table generator d. query language

d. query language

________ is the de facto query language and data access standard supported by the majority of DBMS vendors. a. Structured Query Language b. 4GL c. Access Query Language d. DBMS

a. Structured Query Language

A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people. a. analysis b. review c. footprint d. blueprint

d. blueprint

A customer ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit. a. relationship b. model c. constraint d. entity

d. entity

The basic building blocks of all data models are entities, attributes, relationships, and ________. a. queries b. constraints c. business rules d. multiples

b. constraints

What type of relationship is expressed with the phrase "Painter paints Painting"? a. M:N b. M:1 c. 1:M d. 1:1

c. 1:M

What type of relationship is expressed with the phrase "Employee manages Store"? a. 1:M b. 1:1 c. M:N d. M:1

b. 1:1

What type of relationship is expressed with the phrase "Student takes Class"? a. M:N b. 1:1 c. 1:M d. M:1

a. M:N

What is the fastest and most direct source of business rules? a. company documentation b. a database design document c. interviews with end users d. the Internet

c. interviews with end users

A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization. a. attribute b. entity c. constraint d. business rule

d. business rule

As a general rule, a noun in a business rule will translate into a(n) ________ in the model. a. constraint b. entity c. relationship d. attribute

b. entity

The hierarchical database model is based on a ________. a. lack of a child segment b. matrix c. lack of a parent segment d. tree structure

d. tree structure

The hierarchical database model depicts a set of ________ relationships. a. many-to-one b. one-to-many c. many-to-many d. one-to-one

b. one-to-many

A ________ is the equivalent of a file system's record type. a. child b. parent c. segment d. root

c. segment

Which data model was developed most recently? a. network model b. relational c. XML d. file system

c. XML

Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator. a. subschema b. data management language c. schema d. DBTG

c. schema

A relational database is a collection of ________. a. field values b. tables c. common fields d. records

b. tables

A relation is a matrix consisting of a series of row and column ________. a. intersections b. models c. links d. systems

a. intersections

One of the advantages of a relational data model is ________. a. structural dependence b. easier database design c. complex database design d. conceptual complexity

b. easier database design

For most relational database software, the query language is ________. a. RDBMS b. 4GL c. String Query Language (SQL) d. Structured Query Language (SQL)

d. Structured Query Language (SQL)

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 ________. a. relationships between the tables b. business rules c. RDBMS d. SQL engine

d. SQL engine

Each row in the relational table is known as an entity ________. a. relationship b. instance c. model d. attribute

b. instance

How is an entity represented in an ERD? a. diamond b. triangle c. circle d. rectangle

d. rectangle

What is the name for the most current (and most used) notation of the ERD? a. Chen model b. SQL c. Crow's Foot notation d. Date model

c. Crow's Foot notation

In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________. a. attribute b. object c. entity d. constraint

b. object

Classes are organized as a class ________. a. object b. system c. hierarchy d. method

c. hierarchy

In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's name. a. interface b. method c. inheritance d. hierarchy

b. method

The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications. a. educational b. personal c. non-commercial Internet d. very specialized engineering and scientific

d. very specialized engineering and scientific

Database models can be grouped into two categories: conceptual models and ________ models. a. query b. physical c. logical d. implementation

d. implementation

XML databases have emerged to address the need to manage ________ data within the native XML format. a. structured b. relational c. unstructured d. object-oriented

c. unstructured

Data models were developed to ________. a. allow DBMSs to maintain loose control over the database activities b. deposit data within a single file c. model real-world objects or events d. keep data within multiple data repositories

c. model real-world objects or events

Which model represents the end users' view of the data environment? a. internal b. conceptual c. physical d. external

d. external

The most widely used conceptual model is the ________ model. a. OO b. implementation c. E-R d. internal

c. E-R

The ________ model presents a global view of the entire database. a. logical b. conceptual c. network d. physical

b. conceptual

A(n) ________ model is independent of both hardware and software. a. developmental b. conceptual c. external d. logical

b. conceptual

Which model operates at the lowest level of abstraction? a. internal b. conceptual c. external d. physical

d. physical

Which model is the representation of the database as “seen” by the DBMS? a. internal b. conceptual c. physical d. external

a. internal

Ch. 1 & Ch. 2 Flashcards

(66 cards)