Question 1

In a file-oriented information system, a work file ____.

Accepted Answer

A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task 
A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task

Question 2

In a file-oriented information system, a security file ____.

Accepted Answer

A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task 
A)  stores relatively permanent data about an entity 
B)  is created and saved for backup and recovery purposes 
C)  stores records that contain day-to-day business and operational data 
D)  is a temporary file created by an information system for a single task

Question 3

Relational databases can run on many platforms, including personal computers.

Accepted Answer

A) True 
 B)False

Question 4

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?

Accepted Answer

A)  candidate key 
B)  concatenated key 
C)  foreign key 
D)  secondary key 
A)  candidate key 
B)  concatenated key 
C)  foreign key 
D)  secondary key

Question 5

____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data

Accepted Answer

A)  JDBC 
B)  JVC 
C)  ODBC 
D)  OEC 
A)  JDBC 
B)  JVC 
C)  ODBC 
D)  OEC

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.

Accepted Answer

A) UML 
B) cardinality 
C) secondary key 
D) data mining 
E) orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical 
A) UML 
B) cardinality 
C) secondary key 
D) data mining 
E) orphan
F)subschema
G)intranet
H)entity
I)physical
J)logical

Question 7

In an M:N relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics.

Accepted Answer

A) True 
 B)False

Question 8

All system files and databases must be backed up regularly and a series of ____________________ copies must be retained for a specific period of time.

Accepted Answer

The answer of All system files and databases must be...

Question 9

In a table or file, each column represents a record, which is an individual instance, or occurrence of an entity, and each row represents a field, or characteristic of the entity.

Accepted Answer

A) True 
 B)False

Question 10

-In the accompanying figure, a ____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

Accepted Answer

A)  primary key 
B)  common key 
C)  secondary key 
D)  combination key 
A)  primary key 
B)  common key 
C)  secondary key 
D)  combination key

Question 11

Most date formats now are based on the model established by the International Organization for Standardization (ISO), which requires a format of ____.

Accepted Answer

A)  two digits for the year, two for the month, and two for the day (YYMMD
D)  
B)  two digits for the year, four for the month, and two for the day (YYMMMMD
D)  
C)  four digits for the year, two for the month, and two for the day (YYYYMMD
D)  
D)  four digits for the year, two for the month, and four for the day (YYYYMMDDD
D)  
A)  two digits for the year, two for the month, and two for the day (YYMMD
D)  
B)  two digits for the year, four for the month, and two for the day (YYMMMMD
D)  
C)  four digits for the year, two for the month, and two for the day (YYYYMMD
D)  
D)  four digits for the year, two for the month, and four for the day (YYYYMMDDD
D)

Question 12

A data warehouse allows users to specify certain dimensions, or characteristics.

Accepted Answer

A) True 
 B)False

Question 13

When a system reads a physical record, it loads the data from storage into a ____, which is a segment of computer memory.

Accepted Answer

A)  client 
B)  table 
C)  password 
D)  buffer 
A)  client 
B)  table 
C)  password 
D)  buffer

Question 14

____________________ codes distinguish items by using a series of subgroups of digits.

Accepted Answer

The answer of ____________________ codes distinguish items by using a...

Question 15

Perry tells Eamon that systems that interact with a database management system do not need to know about the underlying data structures used to store the physical data. As a result, a database administrator has the flexibility to change these underlying data structures without modifying the systems that use the data. What is the name of this feature of database management systems?

Accepted Answer

A)  data scalability 
B)  data authorization 
C)  data flexibility 
D)  data independence 
A)  data scalability 
B)  data authorization 
C)  data flexibility 
D)  data independence

Question 16

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

Accepted Answer

•Consider the work necessary to change a

Question 17

The actual number of logical records in a physical record is determined by the ____________________.

Accepted Answer

The answer of The actual number of logical records in...

Question 18

In the event of a file catastrophe, ____ can be used to restore the file or database to its current state at the time of the last backup.

Accepted Answer

A)  recovery procedures 
B)  crow's foot notation 
C)  audit log files 
D)  standard notation format 
A)  recovery procedures 
B)  crow's foot notation 
C)  audit log files 
D)  standard notation format

Question 19

Web pages are stored on a Web server, which is a computer that receives requests and makes Web pages available to users.

Accepted Answer

A) True 
 B)False

Question 20

In a Web-based database design, the Internet serves as the ____ for the database management system.

Accepted Answer

A)  front end 
B)  back end 
C)  middleware 
D)  interface 
A)  front end 
B)  back end 
C)  middleware 
D)  interface

In a file-oriented information system, a work file ____.

In a file-oriented information system, a security file ____.

Relational databases can run on many platforms, including personal computers.

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?

____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.

In an M:N relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics.

All system files and databases must be backed up regularly and a series of ____________________ copies must be retained for a specific period of time.

In a table or file, each column represents a record, which is an individual instance, or occurrence of an entity, and each row represents a field, or characteristic of the entity.

-In the accompanying figure, a ____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

Most date formats now are based on the model established by the International Organization for Standardization (ISO), which requires a format of ____.

A data warehouse allows users to specify certain dimensions, or characteristics.

When a system reads a physical record, it loads the data from storage into a ____, which is a segment of computer memory.

____________________ codes distinguish items by using a series of subgroups of digits.

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

The actual number of logical records in a physical record is determined by the ____________________.

In the event of a file catastrophe, ____ can be used to restore the file or database to its current state at the time of the last backup.

Web pages are stored on a Web server, which is a computer that receives requests and makes Web pages available to users.

In a Web-based database design, the Internet serves as the ____ for the database management system.

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

Communication Tools

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters

Exam 9: Data Design

In a file-oriented information system, a work file ____.

In a file-oriented information system, a security file ____.

Relational databases can run on many platforms, including personal computers.

Malia asks if it is possible to retrieve records using a field or combination of fields that is not unique. Michelle informs her that it is. What is the name for this type of key?

____ is an industry-standard protocol that makes it possible for software from different vendors to interact and exchange data

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Kind of storage that is strictly hardware-related, because it involves the process of reading and writing binary data to physical media.

In an M:N relationship, the two entities are linked by an event or transaction called an associative entity, which has its own set of attributes and characteristics.

All system files and databases must be backed up regularly and a series of ____________________ copies must be retained for a specific period of time.

In a table or file, each column represents a record, which is an individual instance, or occurrence of an entity, and each row represents a field, or characteristic of the entity.

-In the accompanying figure, a ____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

Most date formats now are based on the model established by the International Organization for Standardization (ISO), which requires a format of ____.

A data warehouse allows users to specify certain dimensions, or characteristics.

When a system reads a physical record, it loads the data from storage into a ____, which is a segment of computer memory.

____________________ codes distinguish items by using a series of subgroups of digits.

Four kinds of problems are found with 1NF designs that do not exist in 2NF. What are they?

The actual number of logical records in a physical record is determined by the ____________________.

In the event of a file catastrophe, ____ can be used to restore the file or database to its current state at the time of the last backup.

Web pages are stored on a Web server, which is a computer that receives requests and makes Web pages available to users.

In a Web-based database design, the Internet serves as the ____ for the database management system.

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

Communication Tools

CASE Tools

Financial Analysis Tools

Internet Resource Tools

Filters