Question 1

A good data model is essentially non-redundant. This means that each data attribute, other than foreign keys, describes at most one entity.

Accepted Answer

A) True 
 B)False

Question 2

A significant disadvantage of ___________________ (conventional files or databases) is their inflexibility and non-scalability.

Accepted Answer

The answer of A significant disadvantage of ___________________ (conventional files...

Question 3

SQL allows you to __________________ two or more tables across a common field (a primary and a foreign key).

Accepted Answer

The answer of SQL allows you to __________________ two or...

Question 4

Files that contain relatively static data that can be shared by applications to maintain consistency and improve performance are known as:

Accepted Answer

A)  document 
B)  table look-up 
C)  archival 
D)  audit 
E)  none of these 
A)  document 
B)  table look-up 
C)  archival 
D)  audit 
E)  none of these

Question 5

The database technology used to support data architecture is called:

Accepted Answer

A)  database architecture 
B)  network architecture 
C)  systems architecture 
D)  data architecture 
E)  none of these 
A)  database architecture 
B)  network architecture 
C)  systems architecture 
D)  data architecture 
E)  none of these

Question 6

As enterprise systems and applications are re-engineered, the trend is overwhelmingly in favor of replacing database systems and applications with legacy file-based systems and applications.

Accepted Answer

A) True 
 B)False

Question 7

The physical, relational database implementation of a data model is known as a:

Accepted Answer

A)  scenario 
B)  role model 
C)  schema 
D)  primary data model 
E)  none of these 
A)  scenario 
B)  role model 
C)  schema 
D)  primary data model 
E)  none of these

Question 8

When a table or entire rows in a table are assigned to different database servers and locations, it is known as:

Accepted Answer

A)  centralization 
B)  horizontal distribution 
C)  vertical distribution 
D)  replication 
E)  none of these 
A)  centralization 
B)  horizontal distribution 
C)  vertical distribution 
D)  replication 
E)  none of these

Question 9

Triggers are programs embedded within a table that are automatically invoked by updates to another table.

Accepted Answer

A) True 
 B)False

Question 10

A fundamental characteristic of SQL is that commands return a set of records.

Accepted Answer

A) True 
 B)False

Question 11

In a relational database ach table (sometimes called a relation) consists of named columns (which are fields or attributes) and any number of unnamed rows (which correspond to records).

Accepted Answer

A) True 
 B)False

Question 12

Fields whose values identify one and only one record in a file are called:

Accepted Answer

A)  foreign keys 
B)  primary keys 
C)  alternative keys 
D)  concatenated keys 
E)  none of these 
A)  foreign keys 
B)  primary keys 
C)  alternative keys 
D)  concatenated keys 
E)  none of these

Question 13

________________________________ files and tables contain stored copies of historical data for easy retrieval and review without the overhead of regeneration.

Accepted Answer

The answer of ________________________________ files and tables contain stored copies...

Question 14

________________________________ are programs embedded within a table that can be called from an application program.

Accepted Answer

The answer of ________________________________ are programs embedded within a table...

Question 15

A(n) _____________________________ is the physical model or blueprint for a database. It represents the technical implementation of the logical data model.

Accepted Answer

The answer of A(n) _____________________________ is the physical model or...

Question 16

A data manipulation language (DML) is used to create, read, update, and delete records in the database and to navigate between different records and types of records.

Accepted Answer

A) True 
 B)False

Question 17

Many information systems shops hesitate to give end users access to operational databases for queries and reports.

Accepted Answer

A) True 
 B)False

Question 18

File technology is more complex than database technology.

Accepted Answer

A) True 
 B)False

Question 19

During the creation of database schemas, NULL means the field must have a value; whereas, NOT NULL means the field must not have a value.

Accepted Answer

A) True 
 B)False

Question 20

Archival files and tables contain master and transaction file records that have been moved from on-line storage to off-line storage.

Accepted Answer

A) True 
 B)False

A good data model is essentially non-redundant. This means that each data attribute, other than foreign keys, describes at most one entity.

A significant disadvantage of ___________________ (conventional files or databases) is their inflexibility and non-scalability.

SQL allows you to __________________ two or more tables across a common field (a primary and a foreign key).

Files that contain relatively static data that can be shared by applications to maintain consistency and improve performance are known as:

The database technology used to support data architecture is called:

As enterprise systems and applications are re-engineered, the trend is overwhelmingly in favor of replacing database systems and applications with legacy file-based systems and applications.

The physical, relational database implementation of a data model is known as a:

When a table or entire rows in a table are assigned to different database servers and locations, it is known as:

Triggers are programs embedded within a table that are automatically invoked by updates to another table.

A fundamental characteristic of SQL is that commands return a set of records.

In a relational database ach table (sometimes called a relation) consists of named columns (which are fields or attributes) and any number of unnamed rows (which correspond to records).

Fields whose values identify one and only one record in a file are called:

________________________________ files and tables contain stored copies of historical data for easy retrieval and review without the overhead of regeneration.

________________________________ are programs embedded within a table that can be called from an application program.

A(n) _____________________________ is the physical model or blueprint for a database. It represents the technical implementation of the logical data model.

A data manipulation language (DML) is used to create, read, update, and delete records in the database and to navigate between different records and types of records.

Many information systems shops hesitate to give end users access to operational databases for queries and reports.

File technology is more complex than database technology.

During the creation of database schemas, NULL means the field must have a value; whereas, NOT NULL means the field must not have a value.

Archival files and tables contain master and transaction file records that have been moved from on-line storage to off-line storage.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

Exam 14: Database Design

A good data model is essentially non-redundant. This means that each data attribute, other than foreign keys, describes at most one entity.

A significant disadvantage of ___________________ (conventional files or databases) is their inflexibility and non-scalability.

SQL allows you to __________________ two or more tables across a common field (a primary and a foreign key).

Files that contain relatively static data that can be shared by applications to maintain consistency and improve performance are known as:

The database technology used to support data architecture is called:

As enterprise systems and applications are re-engineered, the trend is overwhelmingly in favor of replacing database systems and applications with legacy file-based systems and applications.

The physical, relational database implementation of a data model is known as a:

When a table or entire rows in a table are assigned to different database servers and locations, it is known as:

Triggers are programs embedded within a table that are automatically invoked by updates to another table.

A fundamental characteristic of SQL is that commands return a set of records.

In a relational database ach table (sometimes called a relation) consists of named columns (which are fields or attributes) and any number of unnamed rows (which correspond to records).

Fields whose values identify one and only one record in a file are called:

________________________________ files and tables contain stored copies of historical data for easy retrieval and review without the overhead of regeneration.

________________________________ are programs embedded within a table that can be called from an application program.

A(n) _____________________________ is the physical model or blueprint for a database. It represents the technical implementation of the logical data model.

A data manipulation language (DML) is used to create, read, update, and delete records in the database and to navigate between different records and types of records.

Many information systems shops hesitate to give end users access to operational databases for queries and reports.

File technology is more complex than database technology.

During the creation of database schemas, NULL means the field must have a value; whereas, NOT NULL means the field must not have a value.

Archival files and tables contain master and transaction file records that have been moved from on-line storage to off-line storage.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters