Question 1

Users access the database

Accepted Answer

A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above 
A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above

Question 2

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

A) True 
 B)False

Question 3

An ER diagram is a graphical representation of a data model.

Accepted Answer

A) True 
 B)False

Question 4

Each of the following is a relational algebra function except

Accepted Answer

A)  join 
B)  project 
C)  link 
D)  restrict 
A)  join 
B)  project 
C)  link 
D)  restrict

Question 5

A user view

Accepted Answer

A)  presents the physical arrangement of records in a database for a particular user 
B)  is the logical abstract structure of the database 
C)  specifies the relationship of data elements in the database 
D)  defines how a particular user sees the database 
A)  presents the physical arrangement of records in a database for a particular user 
B)  is the logical abstract structure of the database 
C)  specifies the relationship of data elements in the database 
D)  defines how a particular user sees the database

Question 6

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

Question 7

Use the following words to complete the sentences.
 $\begin{array}{ll}
\text { database administrator } & \text { data dictionary } \
\text { data redundancy } & \text { index sequential access method } \
\text { query language } & \text { schema } \
\text { sequential structure } & \text { subschema }
\end{array}$ 
-The __________________________ authorizes access to the database.

Accepted Answer

database a

Question 8

What is the update anomaly?

Accepted Answer

The update anomaly results from data red

Question 9

Use the following words to complete the sentences.
 $\begin{array}{ll}
\text { database administrator } & \text { data dictionary } \
\text { data redundancy } & \text { index sequential access method } \
\text { query language } & \text { schema } \
\text { sequential structure } & \text { subschema }
\end{array}$ 
-The conceptual view of the database is often called ____________________.

Accepted Answer

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

Question 10

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

Question 11

The update anomaly in unnormalized databases

Accepted Answer

A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions 
A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions

Question 12

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

Accepted Answer

In a centralized database,a lockout is u

Question 15

A table is in third normal form when it is

Accepted Answer

A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above 
A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above

Question 16

What is repeating group data?

Accepted Answer

Repeating group data is the ex

Question 17

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The entire database is replicated at eac

Question 18

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False

Question 19

Use the following words to complete the sentences.
 $\begin{array}{ll}
\text { database administrator } & \text { data dictionary } \
\text { data redundancy } & \text { index sequential access method } \
\text { query language } & \text { schema } \
\text { sequential structure } & \text { subschema }
\end{array}$ 
-The __________________________ describes every data element in the database.

Accepted Answer

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

Question 20

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

Users access the database

The database approach to data management is sometimes called the flat file approach.

An ER diagram is a graphical representation of a data model.

Each of the following is a relational algebra function except

A user view

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

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 __________________________ authorizes access to the database.

What is the update anomaly?

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 ____________________.

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

The update anomaly in unnormalized databases

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

Data currency is preserved in a centralized database by

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

A table is in third normal form when it is

What is repeating group data?

What is a replicated database and what are the advantages of this approach?

A join builds a new table by creating links.

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.

Which statement is not correct? A query language like SQL

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

General Ledger,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

Users access the database

The database approach to data management is sometimes called the flat file approach.

An ER diagram is a graphical representation of a data model.

Each of the following is a relational algebra function except

A user view

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

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 __________________________ authorizes access to the database.

What is the update anomaly?

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 ____________________.

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

The update anomaly in unnormalized databases

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

Data currency is preserved in a centralized database by

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

A table is in third normal form when it is

What is repeating group data?

What is a replicated database and what are the advantages of this approach?

A join builds a new table by creating links.

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.

Which statement is not correct? A query language like SQL

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

General Ledger,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