Filters
Question type

Study Flashcards

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


A) Entity-relationship diagram
B) Data model
C) Database
D) Relational database model

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

What kind of attribute is age?


A) Null-valued attribute
B) Multi-valued attribute
C) Derived attribute
D) Stored attribute

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

What is a characteristic of a table?


A) Field
B) Table
C) Record
D) Key

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

Correct Answer

verifed

verified

Which of the following statements is accurate?


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

E) A) and C)
F) B) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

What is a collection of related data elements?


A) Field
B) Table
C) Record
D) Key

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

What expresses the specific number of instances in an entity?


A) Cardinality
B) Composite entity
C) Business rule
D) Null-valued attribute

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

Correct Answer

verifed

verified

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


A) Field
B) Table
C) Record
D) Key

E) A) and B)
F) C) and D)

Correct Answer

verifed

verified

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


A) Single-valued attribute
B) Multi-valued attribute
C) Null-valued attribute
D) All of these choices

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

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


A) Single-valued attribute
B) Multi-valued attribute
C) Derived attribute
D) Stored attribute

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

What is a primary key?


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 records

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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


A) One-to-one relationship
B) One-to-many relationship
C) Many-to-many relationship
D) Composite entity

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

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


A) Null-valued attribute
B) Multi-valued attribute
C) Single-valued attribute
D) Stored attribute

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

A

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


A) One-to-one relationship
B) One-to-many relationship
C) Many-to-many relationship
D) Composite entity

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

Date of birth would be a stored attribute.

A) True
B) False

Correct Answer

verifed

verified

What is a statement that defines an aspect of a business?


A) Attribute
B) Entity
C) Business relational diagram
D) Business rule

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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


A) Single-valued attribute
B) Multi-valued attribute
C) Null-valued attribute
D) All of these choices

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Which of the following is a possible business rule?


A) A customer can purchase many DVDs
B) DVDs can be purchased by many customers
C) A DVD title can have many copies
D) All of these choices

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

D

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


A) One-to-one relationship
B) One-to-many relationship
C) Many-to-many relationship
D) Composite entity

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

Correct Answer

verifed

verified

A

Showing 1 - 20 of 27

Related Exams

Show Answer