Question 1

A lockout is a software control that prevents multiple users from simultaneous access to data.

Accepted Answer

A) True 
 B)False

Question 2

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER)diagram is t

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

In the relational model,a data element is called a relation.

Accepted Answer

A) True 
 B)False

Question 5

Which duty is not the responsibility of the database administrator?

Accepted Answer

A)  to develop and maintain the data dictionary 
B)  to implement security controls 
C)  to design application programs 
D)  to design the subschema 
A)  to develop and maintain the data dictionary 
B)  to implement security controls 
C)  to design application programs 
D)  to design the subschema

Question 6

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Accepted Answer

Data redundancy causes significant data

Question 7

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Accepted Answer

A) True 
 B)False

Question 8

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

Data redundancy is not a probl

Question 10

The data definition language

Accepted Answer

A)  identifies,for the database management system,the names and relationships of all data elements,records,and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database 
A)  identifies,for the database management system,the names and relationships of all data elements,records,and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database

Question 11

Explain the three types of anomalies associated with database tables that have not been normalized.

Accepted Answer

The update anomaly is the result of data

Question 12

In the database method of data management,access authority is maintained by systems programming.

Accepted Answer

A) True 
 B)False

Question 13

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 14

In a relational database

Accepted Answer

A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL)is used to create a user's view of the database 
A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL)is used to create a user's view of the database

Question 15

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

Accepted Answer

A) True 
 B)False

Question 16

The database management system provides a controlled environment for accessing the database.

Accepted Answer

A) True 
 B)False

Question 17

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

Question 18

An example of a distributed database is

Accepted Answer

A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases 
A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases

Question 19

Describe an environment in which a firm should use a partitioned database.

Accepted Answer

A partitioned database approac

Question 20

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 ____________________ allows users to retrieve and modify data easily.

Accepted Answer

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

A lockout is a software control that prevents multiple users from simultaneous access to data.

Explain the purpose of an ER diagram in database design.

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

In the relational model,a data element is called a relation.

Which duty is not the responsibility of the database administrator?

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

A customer name and an unpaid balance is an example of a one-to-many relationship.

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

The data definition language

Explain the three types of anomalies associated with database tables that have not been normalized.

In the database method of data management,access authority is maintained by systems programming.

What is view integration?

In a relational database

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

The database management system provides a controlled environment for accessing the database.

What is a transitive dependency?

An example of a distributed database is

Describe an environment in which a firm should use a partitioned database.

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 ____________________ allows users to retrieve and modify data easily.

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

A lockout is a software control that prevents multiple users from simultaneous access to data.

Explain the purpose of an ER diagram in database design.

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

In the relational model,a data element is called a relation.

Which duty is not the responsibility of the database administrator?

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

A customer name and an unpaid balance is an example of a one-to-many relationship.

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

The data definition language

Explain the three types of anomalies associated with database tables that have not been normalized.

In the database method of data management,access authority is maintained by systems programming.

What is view integration?

In a relational database

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

The database management system provides a controlled environment for accessing the database.

What is a transitive dependency?

An example of a distributed database is

Describe an environment in which a firm should use a partitioned database.

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 ____________________ allows users to retrieve and modify data easily.

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