Question 1

A _____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

Accepted Answer

A)  data warehouse 
B)  data frame 
C)  pseudo-data 
D)  metadata 
A)  data warehouse 
B)  data frame 
C)  pseudo-data 
D)  metadata

Question 2

List and discuss at least 5 specific database management system (DBMS) advantages.

Accepted Answer

• Scalability: Scalability means that a

Question 3

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

Accepted Answer

A)  12 
B)  24 
C)  30 
D)  32 
A)  12 
B)  24 
C)  30 
D)  32

Question 4

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Accepted Answer

A)  Scalability 
B)  Compatibility 
C)  Cardinality 
D)  Functionality 
A)  Scalability 
B)  Compatibility 
C)  Cardinality 
D)  Functionality

Question 5

Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

Accepted Answer

A) True 
 B)False

Question 6

Matching
​Identify the letters of the choices that best match the phrases or definitions.
-Could help a consumer products firm identify potential customers based on their prior purchases

Accepted Answer

A) ​Unified Modeling Language (UML) 
B) ​Cardinality 
C) ​Foreign key 
D) ​Data mining 
E) ​​Referential integrity
F)Subschema
G)​Extended Binary Coded Decimal Interchange Code (EBCDI
C) 
H)Entity
I)Logical record
J)Logical storage 
A) ​Unified Modeling Language (UML) 
B) ​Cardinality 
C) ​Foreign key 
D) ​Data mining 
E) ​​Referential integrity
F)Subschema
G)​Extended Binary Coded Decimal Interchange Code (EBCDI
C) 
H)Entity
I)Logical record
J)Logical storage

A _____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

List and discuss at least 5 specific database management system (DBMS) advantages.

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

Matching Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Appendix-The Systems Analyst’s Toolkit

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters

Exam 9: Data Design

A _____ is an integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company.

List and discuss at least 5 specific database management system (DBMS) advantages.

A long integer format uses _____ bits to represent the number 1,234,567,890 in binary form.

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Audit log files, which record details of all accesses and changes to a file or database, can be used to recover changes made since the last backup.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Appendix-The Systems Analyst’s Toolkit

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters

Matching Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases