Question 1

List the four DBMS "languages." Provide a brief description which identifies who uses them and for what purpose.

Accepted Answer

DDL is the data definition language used...

Question 2

Shandra Bundawi is a new graduate who has been hired by an old-line,family-owned furniture manufacturing company in the northeast.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

Accepted Answer

A)  independence.
B)  integration.
C)  redundancy.
D)  qualifications.E) B) and D)
F) A) and B)

Question 3

Data that are classified in terms of geographic regions can be presented in reports that are displayed as maps with color or texture differences that indicate different values of the measure of interest,such as population,income level,age,etc.This view of a database is an example of a(an)

Accepted Answer

A)  External level schema
B)  Conceptual level schema
C)  Internal level schema
D)  Base level schemaE) All of the above
F) A) and B)

Question 4

The ____________ contains information about the structure of the database.

Accepted Answer

A)  Data definition language
B)  Data dictionary
C)  Data warehouse
D)  Database management systemE) A) and D)
F) All of the above

Question 5

What is one potential drawback in the design and implementation of database systems for accounting?

Accepted Answer

A)  Double-entry accounting relies on redundancy as part of the accounting process; well-designed database systems reduce and attempt to eliminate redundancy.
B)  Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine.
C)  Relational DBMS provide the capability of integrating financial and operational data.
D)  Relational DBMS can accommodate multiple views of the same underlying phenomenon; therefore,tables storing information about assets can include data about both historical and replacement costs.E) None of the above
F) C) and D)

Question 6

All of the following are benefits of database technology except:

Accepted Answer

A)  Data integration and sharing
B)  Decentralized management of data
C)  Minimal data redundancy
D)  Reporting flexibilityE) B) and C)
F) C) and D)

Question 7

One important constraint in a relational database environment is that a primary key uniquely identifies each row in a data table.This principle is called the

Accepted Answer

A)  entity integrity rule.
B)  referential integrity rule.
C)  unique primary key rule.
D)  foreign key rule.E) A) and C)
F) B) and D)

Question 8

Creating an empty table in a relational database requires use of the __________,and filling that table requires the use of __________.

Accepted Answer

A)  DDL; DML
B)  DQL; SQL
C)  DDL; DQL
D)  DML; DDAE) A) and C)
F) A) and B)

Question 9

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Accepted Answer

A schema describes the logical structure...

Question 10

The data dictionary usually is maintained

Accepted Answer

A)  automatically by the DBMS.
B)  by the database administrator.
C)  by the database programmers.
D)  by top management.E) B) and D)
F) A) and C)

Question 11

The abstract representation of the contents of a database is called the logical

Accepted Answer

A)  data model.
B)  data dictionary.
C)  data relationship.
D)  subschemas.E) All of the above
F) B) and D)

Question 12

A set of individual user views of the database is called the

Accepted Answer

A)  schema.
B)  internal-level schema.
C)  external-level schema.
D)  meta-schema.E) All of the above
F) B) and C)

Question 13

The DBMS language that is used for data maintenance and updating of the database is referred to by the letters

Accepted Answer

A)  DDL.
B)  DML.
C)  DQL.
D)  SQL.E) None of the above
F) A) and D)

Question 14

There are two basic ways to design a well-structured relational database.The method in which a database designer uses knowledge about how business processes work to draw a graphical picture of the elements to be included in the database is called

Accepted Answer

A)  normalization.
B)  decentralization.
C)  geometric data modeling.
D)  semantic data modeling.E) A) and B)
F) B) and C)

Question 15

Which one of the following results corresponds to the query below?

Accepted Answer

A)   
B)   
C)   
D)   E) All of the above
F) A) and D)

Question 16

List the four languages used within a DBMS.

Accepted Answer

The four languages used within...

Question 17

Schemas are used in designing database systems.The schema that provides an organization-wide view of the entire database is known as

Accepted Answer

A)  the external-level schema.
B)  the internal-level schema.
C)  the conceptual-level schema.
D)  the logical view of the database.E) A) and C)
F) A) and D)

Question 18

The database constraint that says that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Accepted Answer

A)  entity integrity rule.
B)  referential integrity rule.
C)  rule of keys.
D)  referential entity rule.E) A) and B)
F) A) and C)

Question 19

The attribute that can uniquely identify a specific row in a table is the

Accepted Answer

A)  primary key
B)  secondary key
C)  foreign key
D)  logical keyE) None of the above
F) All of the above

Question 20

Which is probably the most significant effect of database technology on accounting?

Accepted Answer

A)  replacement of the double entry-system
B)  change in the nature of financial reporting
C)  elimination of traditional records such as journals and ledgers
D)  quicker access to and greater use of accounting information in decision-makingE) A) and B)
F) B) and D)

Exam 4: Relational Databases

Data that are classified in terms of geographic regions can be presented in reports that are displayed as maps with color or texture differences that indicate different values of the measure of interest,such as population,income level,age,etc.This view of a database is an example of a(an)

Correct Answer
verified

The data dictionary usually is maintained

Correct Answer
verified

The abstract representation of the contents of a database is called the logical

Correct Answer
verified

The DBMS language that is used for data maintenance and updating of the database is referred to by the letters

Correct Answer
verified

There are two basic ways to design a well-structured relational database.The method in which a database designer uses knowledge about how business processes work to draw a graphical picture of the elements to be included in the database is called

Correct Answer
verified

Which is probably the most significant effect of database technology on accounting?

Correct Answer
verified

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Correct Answer
verified
A schema describes the logical structure...
View Answer

One important constraint in a relational database environment is that a primary key uniquely identifies each row in a data table.This principle is called the

Correct Answer
verified

All of the following are benefits of database technology except:

Correct Answer
verified

What is one potential drawback in the design and implementation of database systems for accounting?

Correct Answer
verified

The ____________ contains information about the structure of the database.

Correct Answer
verified

A set of individual user views of the database is called the

Correct Answer
verified

The attribute that can uniquely identify a specific row in a table is the

Correct Answer
verified

Correct Answer
verified

The database constraint that says that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Correct Answer
verified

Creating an empty table in a relational database requires use of the ,and filling that table requires the use of .

Correct Answer
verified

Schemas are used in designing database systems.The schema that provides an organization-wide view of the entire database is known as

Correct Answer
verified

Which one of the following results corresponds to the query below?

Correct Answer
verified

List the four languages used within a DBMS.

Correct Answer
verified
The four languages used within...
View Answer

List the four DBMS "languages." Provide a brief description which identifies who uses them and for what purpose.

Correct Answer
verified
DDL is the data definition language used...
View Answer

Exam 4: Relational Databases

Data that are classified in terms of geographic regions can be presented in reports that are displayed as maps with color or texture differences that indicate different values of the measure of interest,such as population,income level,age,etc.This view of a database is an example of a(an)

Correct AnswerverifiedShow Answer

The data dictionary usually is maintained

Correct AnswerverifiedShow Answer

The abstract representation of the contents of a database is called the logical

Correct AnswerverifiedShow Answer

The DBMS language that is used for data maintenance and updating of the database is referred to by the letters

Correct AnswerverifiedShow Answer

There are two basic ways to design a well-structured relational database.The method in which a database designer uses knowledge about how business processes work to draw a graphical picture of the elements to be included in the database is called

Correct AnswerverifiedShow Answer

Which is probably the most significant effect of database technology on accounting?

Correct AnswerverifiedShow Answer

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Correct AnswerverifiedA schema describes the logical structure...View AnswerShow Answer

One important constraint in a relational database environment is that a primary key uniquely identifies each row in a data table.This principle is called the

Correct AnswerverifiedShow Answer

All of the following are benefits of database technology except:

Correct AnswerverifiedShow Answer

What is one potential drawback in the design and implementation of database systems for accounting?

Correct AnswerverifiedShow Answer

The ____________ contains information about the structure of the database.

Correct AnswerverifiedShow Answer

A set of individual user views of the database is called the

Correct AnswerverifiedShow Answer

The attribute that can uniquely identify a specific row in a table is the

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

The database constraint that says that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the

Correct AnswerverifiedShow Answer

Creating an empty table in a relational database requires use of the __________,and filling that table requires the use of __________.

Correct AnswerverifiedShow Answer

Schemas are used in designing database systems.The schema that provides an organization-wide view of the entire database is known as

Correct AnswerverifiedShow Answer

Which one of the following results corresponds to the query below?

Correct AnswerverifiedShow Answer

List the four languages used within a DBMS.

Correct AnswerverifiedThe four languages used within...View AnswerShow Answer

List the four DBMS "languages." Provide a brief description which identifies who uses them and for what purpose.

Correct AnswerverifiedDDL is the data definition language used...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A schema describes the logical structure...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Creating an empty table in a relational database requires use of the ,and filling that table requires the use of .

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The four languages used within...
View Answer

Correct Answer
verified
DDL is the data definition language used...
View Answer