Question 1

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

Accepted Answer

A)  foreign key.
B)  primary key.
C)  relational key.
D)  linkage key.

Question 2

Identify one potential outcome of the insert anomaly.

Accepted Answer

A)  inconsistent data
B)  inability to add new data
C)  unintentional loss of data
D)  none of the above

Question 3

A ________ is an abstract representation of a database's contents.

Accepted Answer

A)  schema
B)  logical data model
C)  physical view
D)  data dictionary

Question 4

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 5

When the human resources manager wants to build a data dictionary,the manager would use which language?

Accepted Answer

A)  Data Manipulation Language
B)  Data Query Language
C)  Data Report Language
D)  Data Definition Language

Question 6

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Accepted Answer

A DBMS will use data definition,data man...

Question 7

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Accepted Answer

A)  Two primary keys
B)  Two foreign keys
C)  At least one column
D)  One foreign key

Question 8

-Using the database depicted above,how many primary keys are in the database?

Accepted Answer

A)  0
B)  3
C)  4
D)  5

Question 9

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.

Question 10

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Accepted Answer

A)  external
B)  conceptual
C)  internal
D)  meta

Question 11

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Accepted Answer

A)  Data Manipulation Language
B)  Data Query Language
C)  Data Report Language
D)  Data Definition Language

Question 12

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Accepted Answer

A)  Data Definition Language
B)  Data Manipulation Language
C)  Data Query Language
D)  Data Update Language

Question 13

-Using the database depicted above,"Item #" is best described as

Accepted Answer

A)  an attribute.
B)  a primary key.
C)  a foreign key.
D)  A,B,and C

Question 14

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A)  Customer Order
B)  Customer
C)  Sales
D)  Sales Order

Question 15

The physical view of a database system refers to

Accepted Answer

A)  how a user or programmer conceptually organizes and understands the data.
B)  how the DBMS accesses data for a certain application program.
C)  how and where the data are physically arranged and stored.
D)  how master files store data values used by more than one application program.

Question 16

In a relational database,requiring that every record in a table have a unique identifier is called the

Accepted Answer

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

Question 17

In a well-structured relational database,

Accepted Answer

A)  foreign keys cannot be null.
B)  there must be at least two foreign keys.
C)  every column in a row must be single valued.
D)  one table must be related to all other tables.

Question 18

The logical view of a database system refers to

Accepted Answer

A)  how a user or programmer conceptually organizes and understands the data.
B)  how the DBMS accesses data for a certain application program.
C)  how and where the data are physically arranged and stored.
D)  how master files store data values used by more than one application program.

Question 19

Seacrest Bedding is changing from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for a sales transaction.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

Accepted Answer

Customer table;ID (primary key),name,str...

Question 20

Describe the information that is contained in the data dictionary.

Accepted Answer

The data dictionary contains information...

Exam 4: Relational Databases

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Correct Answer
verified

The physical view of a database system refers to

Correct Answer
verified

The logical view of a database system refers to

Correct Answer
verified

In a well-structured relational database,

Correct Answer
verified

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Correct Answer
verified

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Correct Answer
verified

Describe the information that is contained in the data dictionary.

Correct Answer
verified
The data dictionary contains information...
View Answer

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Correct Answer
verified
A DBMS will use data definition,data man...
View Answer

A ________ is an abstract representation of a database's contents.

Correct Answer
verified

In a relational database,requiring that every record in a table have a unique identifier is called the

Correct Answer
verified

Correct Answer
verified
Customer table;ID (primary key),name,str...
View Answer

-Using the database depicted above,how many primary keys are in the database?

Correct Answer
verified

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Correct Answer
verified

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

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

The data dictionary usually is maintained

Correct Answer
verified

Identify one potential outcome of the insert anomaly.

Correct Answer
verified

-Using the database depicted above,"Item #" is best described as

Correct Answer
verified

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Correct Answer
verified

When the human resources manager wants to build a data dictionary,the manager would use which language?

Correct Answer
verified

Exam 4: Relational Databases

Suppose a relational database contained two linked tables.Which of the following items is not necessarily present in the database?

Correct AnswerverifiedShow Answer

The physical view of a database system refers to

Correct AnswerverifiedShow Answer

The logical view of a database system refers to

Correct AnswerverifiedShow Answer

In a well-structured relational database,

Correct AnswerverifiedShow Answer

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Correct AnswerverifiedShow Answer

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Correct AnswerverifiedShow Answer

Describe the information that is contained in the data dictionary.

Correct AnswerverifiedThe data dictionary contains information...View AnswerShow Answer

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Correct AnswerverifiedA DBMS will use data definition,data man...View AnswerShow Answer

A ________ is an abstract representation of a database's contents.

Correct AnswerverifiedShow Answer

In a relational database,requiring that every record in a table have a unique identifier is called the

Correct AnswerverifiedShow Answer

Correct AnswerverifiedCustomer table;ID (primary key),name,str...View AnswerShow Answer

-Using the database depicted above,how many primary keys are in the database?

Correct AnswerverifiedShow Answer

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Correct AnswerverifiedShow Answer

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a

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

The data dictionary usually is maintained

Correct AnswerverifiedShow Answer

Identify one potential outcome of the insert anomaly.

Correct AnswerverifiedShow Answer

-Using the database depicted above,"Item #" is best described as

Correct AnswerverifiedShow Answer

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Correct AnswerverifiedShow Answer

When the human resources manager wants to build a data dictionary,the manager would use which language?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The data dictionary contains information...
View Answer

Correct Answer
verified
A DBMS will use data definition,data man...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Customer table;ID (primary key),name,str...
View Answer

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