Question 1

In the relational database model all of the following are true except

Accepted Answer

A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported 
A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported D

Question 2

The textbook refers to four interrelated components of the database concept. Which of the following is not one of the components?

Accepted Answer

A)  the database management system 
B)  the database administrator 
C)  the physical database 
D)  the conceptual database 
A)  the database management system 
B)  the database administrator 
C)  the physical database 
D)  the conceptual database D

Question 3

Explain how linkages between relational tables are accomplished.

Accepted Answer

Logically related tables need to be physically connected to achieve the associations described in the data model. This is accomplished by using foreign keys. The degree of cardinality between the related tables determines the method used for assigning foreign keys.
Where a 1:M (or 1:0,M) association exists, the primary key of the 1 side is embedded in the table of the M side.
To represent the M:M association between tables, a link table needs to be created that has a combined (composite) key consisting of the primary keys of two related tables.

Question 4

Data currency is preserved in a centralized database by

Accepted Answer

A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls 
A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls

Question 5

The task of searching the database to locate a stored record for processing is called

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 6

The data manipulation language

Accepted Answer

A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database 
A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database

Question 7

Use the following words to complete the sentences.
database administrator
data dictionary
data redundancy
index sequential access method
query language
schema
sequential structure
subschema
-The conceptual view of the database is often called ____________________.

Accepted Answer

The answer of Use the following words to complete the...

Question 8

The deletion anomaly in unnormalized databases

Accepted Answer

A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates 
A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates

Question 9

The data definition language is used to insert special database commands into application programs.

Accepted Answer

A) True 
 B)False

Question 10

What are the four elements of the database approach? Explain the role of each.

Accepted Answer

Users are the individuals in the organiz

Question 11

Data concurrency

Accepted Answer

A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered 
A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered

Question 12

Entities are

Accepted Answer

A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision 
A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision

Question 13

Timestamping is a control that is used to ensure database partitioning.

Accepted Answer

A) True 
 B)False

Question 14

Which statement is not correct? A query language like SQL

Accepted Answer

A)  is written in a fourth-generation language 
B)  requires user familiarity with COBOL 
C)  allows users to retrieve and modify data 
D)  reduces reliance on programmers 
A)  is written in a fourth-generation language 
B)  requires user familiarity with COBOL 
C)  allows users to retrieve and modify data 
D)  reduces reliance on programmers

Question 15

Task-data dependency is

Accepted Answer

A)  failure to update the files of all users affected by a change 
B)  another term for data redundancy 
C)  user's inability to obtain additional information as needs change 
D)  none of the above 
A)  failure to update the files of all users affected by a change 
B)  another term for data redundancy 
C)  user's inability to obtain additional information as needs change 
D)  none of the above

Question 16

How does the database approach solve the problem of data redundancy?

Accepted Answer

Data redundancy is not a probl

Question 17

Use the following words to complete the sentences.
database administrator
data dictionary
data redundancy
index sequential access method
query language
schema
sequential structure
subschema
-The __________________________ describes every data element in the database.

Accepted Answer

The answer of Use the following words to complete the...

Question 18

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not a common form of conceptual database model?

Accepted Answer

A)  hierarchical 
B)  network 
C)  sequential 
D)  relational 
A)  hierarchical 
B)  network 
C)  sequential 
D)  relational

Question 20

Discuss the hierarchical database model. What limitation(s) of the hierarchical database model are solved by the network database model?

Accepted Answer

The earliest DBMS were based on the hier

In the relational database model all of the following are true except

The textbook refers to four interrelated components of the database concept. Which of the following is not one of the components?

Explain how linkages between relational tables are accomplished.

Data currency is preserved in a centralized database by

The task of searching the database to locate a stored record for processing is called

The data manipulation language

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The conceptual view of the database is often called ____________________.

The deletion anomaly in unnormalized databases

The data definition language is used to insert special database commands into application programs.

What are the four elements of the database approach? Explain the role of each.

Data concurrency

Entities are

Timestamping is a control that is used to ensure database partitioning.

Which statement is not correct? A query language like SQL

Task-data dependency is

How does the database approach solve the problem of data redundancy?

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ describes every data element in the database.

An entity is any physical thing about which the organization wishes to capture data.

Which of the following is not a common form of conceptual database model?

Discuss the hierarchical database model. What limitation(s) of the hierarchical database model are solved by the network database model?

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics, Fraud, and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting, and Management Reporting Systems

The Rea Approach to Business Process Modeling

Enterprise Resource Planning Systems

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters

Exam 9: Database Management Systems

In the relational database model all of the following are true except

The textbook refers to four interrelated components of the database concept. Which of the following is not one of the components?

Explain how linkages between relational tables are accomplished.

Data currency is preserved in a centralized database by

The task of searching the database to locate a stored record for processing is called

The data manipulation language

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The conceptual view of the database is often called ____________________.

The deletion anomaly in unnormalized databases

The data definition language is used to insert special database commands into application programs.

What are the four elements of the database approach? Explain the role of each.

Data concurrency

Entities are

Timestamping is a control that is used to ensure database partitioning.

Which statement is not correct? A query language like SQL

Task-data dependency is

How does the database approach solve the problem of data redundancy?

Use the following words to complete the sentences. database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ describes every data element in the database.

An entity is any physical thing about which the organization wishes to capture data.

Which of the following is not a common form of conceptual database model?

Discuss the hierarchical database model. What limitation(s) of the hierarchical database model are solved by the network database model?

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics, Fraud, and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting, and Management Reporting Systems

The Rea Approach to Business Process Modeling

Enterprise Resource Planning Systems

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Construct, Deliver, and Maintain Systems Projects

IT Controls Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, Program Changes, and Application Controls

Filters