Multiple Choice
What is the purpose of an index?
A) to show which database objects depend on each other
B) to identify primary, secondary, and alternate keys
C) to improve database performance when queries request a sort order for records
D) to store unique data for each record in the table
Correct Answer:
Verified
Correct Answer:
Verified
Q33: A query includes the DeptID and DeptName
Q34: How would you set up a relationship
Q35: Which of the following statements is not
Q36: In an entity-relationship model (ERM), what does
Q37: What can you create in Access to
Q39: A one-to-many relationship with _ means that
Q40: Which fields should you index in a
Q41: Information-level design is independent of any particular
Q42: In an entity-relationship model (ERM) for a
Q43: Access uses Database Design Language (DBDL) to