Question 1

An alternative to building conventional files is building a:

Accepted Answer

A) data dictionary. 
B) data warehouse. 
C) database. 
D) data model. 
A) data dictionary. 
B) data warehouse. 
C) database. 
D) data model. C

Question 2

Within the realm of metadata,there are record definitions and data item definitions.

Accepted Answer

A) True 
 B)False  True

Question 3

Metadata describes the name given and the length assigned each record.

Accepted Answer

A) True 
 B)False  False

Question 4

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

Accepted Answer

A) data mining. 
B) data warehousing. 
C) data denormalization. 
D) databasing. 
A) data mining. 
B) data warehousing. 
C) data denormalization. 
D) databasing.

Question 5

Which of the following is true when implementing a one-to-many relationship?

Accepted Answer

A) The file on the one end has a foreign key consisting of the primary key of the many end. 
B) The file on the one end has a concatenated key of its primary key and the many end key. 
C) The file on the many end has a foreign key consisting of the primary key on the one end. 
D) The file on the many end has a concatenated key of its primary key and the one end key. 
A) The file on the one end has a foreign key consisting of the primary key of the many end. 
B) The file on the one end has a concatenated key of its primary key and the many end key. 
C) The file on the many end has a foreign key consisting of the primary key on the one end. 
D) The file on the many end has a concatenated key of its primary key and the one end key.

Question 6

What is defined as any data item in a record that is used to identify the record?

Accepted Answer

A) an attribute 
B) a key 
C) a primary key 
D) an entity 
A) an attribute 
B) a key 
C) a primary key 
D) an entity

Question 7

Which file is used when it is necessary to run a program,but no printer is available?

Accepted Answer

A) a master file 
B) a table file 
C) a report file 
D) a work file 
E) a transaction file 
A) a master file 
B) a table file 
C) a report file 
D) a work file 
E) a transaction file

Question 8

An entity subtype is an entity that is used to represent a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 9

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Accepted Answer

A) True 
 B)False

Question 10

Master files contain all the information about a data entity.

Accepted Answer

A) True 
 B)False

Question 11

List and describe the four anomalies that may occur when creating database tables.

Accepted Answer

1. Data redundancy occurs when the same

Question 12

Which word is used interchangeably with the term data item?

Accepted Answer

A) attribute 
B) record 
C) key 
D) tuple 
A) attribute 
B) record 
C) key 
D) tuple

Question 13

Transaction files:

Accepted Answer

A) are large files,containing all main information about an entity. 
B) are used to update master files and produce reports. 
C) cannot contain several record types. 
D) are always stored using indexed-sequential organization. 
A) are large files,containing all main information about an entity. 
B) are used to update master files and produce reports. 
C) cannot contain several record types. 
D) are always stored using indexed-sequential organization.

Question 14

Each separate data entity should create its own master database table.

Accepted Answer

A) True 
 B)False

Question 15

Master files are large and contain all the information about an entity.

Accepted Answer

A) True 
 B)False

Question 16

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

Accepted Answer

A) associative entity. 
B) attributive entity. 
C) entity subtype. 
D) self-join. 
E) ordinal entity. 
A) associative entity. 
B) attributive entity. 
C) entity subtype. 
D) self-join. 
E) ordinal entity.

Question 17

A ________ is a central source of data meant to be shared by many users for a variety of applications.

Accepted Answer

A) database 
B) data dictionary 
C) data warehouse 
D) data model 
A) database 
B) data dictionary 
C) data warehouse 
D) data model

Question 18

Within the realm of ________,there are entities and attributes.

Accepted Answer

A) reality 
B) metadata 
C) relationships 
D) databases 
A) reality 
B) metadata 
C) relationships 
D) databases

Question 19

________ are associations between entities.

Accepted Answer

A) Relationships 
B) Subtypes 
C) Types 
D) Entities 
A) Relationships 
B) Subtypes 
C) Types 
D) Entities

Question 20

Each distinct data entity may be stored on several master database tables.

Accepted Answer

A) True 
 B)False

An alternative to building conventional files is building a:

Within the realm of metadata,there are record definitions and data item definitions.

Metadata describes the name given and the length assigned each record.

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

Which of the following is true when implementing a one-to-many relationship?

What is defined as any data item in a record that is used to identify the record?

Which file is used when it is necessary to run a program,but no printer is available?

An entity subtype is an entity that is used to represent a many-to-many relationship.

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Master files contain all the information about a data entity.

List and describe the four anomalies that may occur when creating database tables.

Which word is used interchangeably with the term data item?

Transaction files:

Each separate data entity should create its own master database table.

Master files are large and contain all the information about an entity.

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

A ________ is a central source of data meant to be shared by many users for a variety of applications.

Within the realm of ________,there are entities and attributes.

________ are associations between entities.

Each distinct data entity may be stored on several master database tables.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

An alternative to building conventional files is building a:

Within the realm of metadata,there are record definitions and data item definitions.

Metadata describes the name given and the length assigned each record.

A process of applying algorithms for extracting patterns from data stored in data warehouses that are typically not apparent to human decision makers is called:

Which of the following is true when implementing a one-to-many relationship?

What is defined as any data item in a record that is used to identify the record?

Which file is used when it is necessary to run a program,but no printer is available?

An entity subtype is an entity that is used to represent a many-to-many relationship.

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Master files contain all the information about a data entity.

List and describe the four anomalies that may occur when creating database tables.

Which word is used interchangeably with the term data item?

Transaction files:

Each separate data entity should create its own master database table.

Master files are large and contain all the information about an entity.

The symbol used to represent additional attributes of another entity that may not be present on every record of the first entity is called an:

A ________ is a central source of data meant to be shared by many users for a variety of applications.

Within the realm of ________,there are entities and attributes.

________ are associations between entities.

Each distinct data entity may be stored on several master database tables.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters