Question 1

What is composed of rows and columns that represent an entity?

Accepted Answer

A)  field
B)  table
C)  record
D)  keyE) A) and B)
F) A) and C)

Question 2

What occurs when two entities can be related to each other in many instances?

Accepted Answer

A)  one-to-one relationship
B)  one-to-many relationship
C)  many-to-many relationship
D)  composite entityE) A) and B)
F) C) and D)

Question 3

A primary key is a field that uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False  True

Question 4

Date of birth would be a stored attribute.

Accepted Answer

A) True 
 B)False  True

Question 5

Which of the following is a type of attribute?

Accepted Answer

A)  single-valued attribute
B)  multivalued attribute
C)  null-valued attribute
D)  All of these are correct.E) All of the above
F) A) and C)

Question 6

What exists to represent the relationship between two other entities?

Accepted Answer

A)  one-to-one relationship
B)  one-to-many relationship
C)  many-to-many relationship
D)  composite entityE) None of the above
F) B) and C) D

Question 7

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

Accepted Answer

A)  one-to-one relationship
B)  one-to-many relationship
C)  many-to-many relationship
D)  composite entityE) B) and C)
F) A) and B)

Question 8

What has only a single value of each attribute of an entity?

Accepted Answer

A)  single-valued attribute
B)  multivalued attribute
C)  null-valued attribute
D)  All of these are correct.E) A) and B)
F) None of the above

Question 9

Which of the following statements is accurate?

Accepted Answer

A)  A correct business rule for one organization may not be correct for another organization.
B)  Each business rule will have entities and sometimes even attributes.
C)  A typical business may have hundreds of business rules.
D)  All of these are correct.E) A) and C)
F) C) and D)

Question 10

What is a foreign key?

Accepted Answer

A)  a field that uniquely identifies a given record in a table
B)  a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
C)  a table that uniquely identifies a given record in a field
D)  a foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two recordsE) B) and D)
F) A) and B)

Question 11

What is a technique for documenting the entities and relationships in a database environment?

Accepted Answer

A)  entity-relationship diagram
B)  data model
C)  database
D)  relational database modelE) B) and C)
F) C) and D)

Question 12

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

Accepted Answer

A)  one-to-one relationship
B)  one-to-many relationship
C)  many-to-many relationship
D)  composite entityE) C) and D)
F) A) and B)

Question 13

A field is composed of rows and columns that represent an entity.

Accepted Answer

A) True 
 B)False

Question 14

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

A) True 
 B)False

Question 15

What kind of attribute would be date of birth?

Accepted Answer

A)  null-valued attribute
B)  multivalued attribute
C)  derived attribute
D)  stored attributeE) None of the above
F) A) and B)

Question 16

What kind of attribute would be given for a person who does not have an email address?

Accepted Answer

A)  null-valued attribute
B)  multivalued attribute
C)  single-valued attribute
D)  stored attributeE) B) and C)
F) None of the above

Question 17

What kind of attribute can be calculated using the value of another attribute?

Accepted Answer

A)  single-valued attribute
B)  multivalued attribute
C)  derived attribute
D)  stored attributeE) B) and C)
F) A) and D)

Question 18

What is a collection of related data elements?

Accepted Answer

A)  field
B)  table
C)  record
D)  keyE) B) and C)
F) All of the above

Question 19

What expresses the specific number of instances in an entity?

Accepted Answer

A)  cardinality
B)  composite entity
C)  business rule
D)  null-valued attributeE) None of the above
F) All of the above

Question 20

What has the potential to contain more than one value for an attribute?

Accepted Answer

A)  single-valued attribute
B)  multivalued attribute
C)  null-valued attribute
D)  All of these are correct.E) A) and B)
F) A) and C)

Exam 12: Designing Data-Bases-Apply Your Knowledge-Glossary

What is composed of rows and columns that represent an entity?

Correct AnswerverifiedShow Answer

What occurs when two entities can be related to each other in many instances?

Correct AnswerverifiedShow Answer

A primary key is a field that uniquely identifies a given record in a table.

Correct AnswerverifiedTrue

Date of birth would be a stored attribute.

Correct AnswerverifiedTrue

Which of the following is a type of attribute?

Correct AnswerverifiedShow Answer

What exists to represent the relationship between two other entities?

Correct AnswerverifiedD

What occurs between two entities in which an instance of one entity can be related to only one instance of a related entity?

Correct AnswerverifiedShow Answer

What has only a single value of each attribute of an entity?

Correct AnswerverifiedShow Answer

Which of the following statements is accurate?

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

What is a technique for documenting the entities and relationships in a database environment?

Correct AnswerverifiedShow Answer

What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?

Correct AnswerverifiedShow Answer

A field is composed of rows and columns that represent an entity.

Correct AnswerverifiedShow Answer

A foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Correct AnswerverifiedShow Answer

What kind of attribute would be date of birth?

Correct AnswerverifiedShow Answer

What kind of attribute would be given for a person who does not have an email address?

Correct AnswerverifiedShow Answer

What kind of attribute can be calculated using the value of another attribute?

Correct AnswerverifiedShow Answer

What is a collection of related data elements?

Correct AnswerverifiedShow Answer

What expresses the specific number of instances in an entity?

Correct AnswerverifiedShow Answer

What has the potential to contain more than one value for an attribute?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified