Filters
Question type

Study Flashcards

Which of the following is a type of attribute?


A) Single-valued attribute
B) Multi-valued attribute
C) Null-valued attribute
D) All of the above

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

Correct Answer

verifed

verified

What is a foreign 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 exists to represent the relationship between two other entities?


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

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

Correct Answer

verifed

verified

D

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) All of the above
F) A) and D)

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) A) and C)
F) B) and C)

Correct Answer

verifed

verified

What is a characteristic of a table?


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

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

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

True

What is a collection of related data elements?


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

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

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) None of the above
F) A) and C)

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 the above

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

Correct Answer

verifed

verified

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.

A) True
B) False

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) None of the above
F) A) and B)

Correct Answer

verifed

verified

What is a technique for documenting 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) All of the above

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 the above.

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

Correct Answer

verifed

verified

What kind of attribute would be date of birth?


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

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

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 the above

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

Correct Answer

verifed

verified

What kind of attribute would be age?


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

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

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) None of the above
F) All of the above

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 C)
F) A) and D)

Correct Answer

verifed

verified

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


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

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

Correct Answer

verifed

verified

B

Showing 1 - 20 of 27

Related Exams

Show Answer