Quiz 7 Flashcards
(16 cards)
What is the main purpose of a primary key in a relational database?
To uniquely identify each record
What feature distinguishes the object-oriented database model from others?
It combines data and methods within objects (encapsulation)
What is the main component of a relational database model?
Tables
Which of the following best defines a foreign key?
A key that links to a primary key in another table
What is the correct order of the ETL process used to move data into a Data Warehouse?
Extract, Transform, Load
Entity Relationship Diagram (ERD), whats the symbol that represents “many” relationships?
Crow’s foot
Which of the following is a benefit of using Data Modeling in database design?
It helps keep data clean, organized, and reduce mistakes
What is a database?
A collection of related data
Which of the following is an example of an entity in a database?
People
What is the smallest piece of data in a database?
Character
Which one of these is NOT a limitation of the traditional file approach?
Strong central security
What does a DBMS allow multiple users to do?
Access and manipulate the same data simultaneously
In the hierarchy of data, which of the following is the correct order from smallest to largest?
Character → Field → Record → File → Database
What is a “file” in the context of a database?
A collection of related records
What is a database query?
A message that requests data
Which of the following is NOT typically a source of database data?
Manual paperwork stored in a drawer
