BTM2000 EXAM 2 GUILLIAMS UPDATED QUESTIONS
AND CORRECT ANSWERS
Question:
1. Metadata
Answer:
Data that describes other data; helps organize, manage, and find data efficient-ly.
Question:
2. Three Major RDBMS (Largest to Smallest)
Answer:
1. Oracle 2. Microsoft SQL Server 3. IBM Db2
Question:
3. Keys and Indices
Answer:
Keys uniquely identify data; indices improve speed of searching and sorting.
Question:
4. Primary Key
Answer:
A unique identifier for each record in a table; no duplicates allowed.
Question:
5. Foreign Key
Answer:
A field linking one table's primary key to another; forms relationships.
Question:
6. Entity
Answer:
A thing or concept about which data is stored (e.g., Customer, Order).
Question:
7. Attributes
Answer:
Characteristics or properties of an entity (e.g., Name, Address).
Question:
8. ERD (Entity Rela-tionship Diagram)
Answer:
A diagram showing entities, attributes, and relationships between data.
Question:
9. Data Model vs. Database Design
, Answer:
Data model: logical structure of data; Database design: implementation of that model.
Question:
10. Maximum Cardinal-ity
Answer:
Defines how many instances of one entity can relate to another (1 or many).
Question:
11. Minimum Cardinali-ty
Answer:
Defines if relationship is optional or required (0 or 1).
Question:
12. SQL
Answer:
Structured Query Language; used to create, read, update, and delete data in relational databases.
Question:
13. Business Process
Answer:
Sequence of activities performed to accomplish a business function.
Question:
14. Activities
Answer:
Tasks or steps within a business process.
Question:
15. BPMN
Answer:
Business Process Modeling Notation; visual language for modeling business processes.
Question:
16. BPMN Symbols
Answer:
Circle=start/end, Rectangle=activity, Diamond=decision, Arrow=flow.
Question:
17. Swimlanes
Answer:
Divides process diagram into lanes by role or department.
Question:
18. Artificial Intelli-gence (AI)
Answer:
Computers performing tasks needing human intelligence; uses machine learn-ing.
AND CORRECT ANSWERS
Question:
1. Metadata
Answer:
Data that describes other data; helps organize, manage, and find data efficient-ly.
Question:
2. Three Major RDBMS (Largest to Smallest)
Answer:
1. Oracle 2. Microsoft SQL Server 3. IBM Db2
Question:
3. Keys and Indices
Answer:
Keys uniquely identify data; indices improve speed of searching and sorting.
Question:
4. Primary Key
Answer:
A unique identifier for each record in a table; no duplicates allowed.
Question:
5. Foreign Key
Answer:
A field linking one table's primary key to another; forms relationships.
Question:
6. Entity
Answer:
A thing or concept about which data is stored (e.g., Customer, Order).
Question:
7. Attributes
Answer:
Characteristics or properties of an entity (e.g., Name, Address).
Question:
8. ERD (Entity Rela-tionship Diagram)
Answer:
A diagram showing entities, attributes, and relationships between data.
Question:
9. Data Model vs. Database Design
, Answer:
Data model: logical structure of data; Database design: implementation of that model.
Question:
10. Maximum Cardinal-ity
Answer:
Defines how many instances of one entity can relate to another (1 or many).
Question:
11. Minimum Cardinali-ty
Answer:
Defines if relationship is optional or required (0 or 1).
Question:
12. SQL
Answer:
Structured Query Language; used to create, read, update, and delete data in relational databases.
Question:
13. Business Process
Answer:
Sequence of activities performed to accomplish a business function.
Question:
14. Activities
Answer:
Tasks or steps within a business process.
Question:
15. BPMN
Answer:
Business Process Modeling Notation; visual language for modeling business processes.
Question:
16. BPMN Symbols
Answer:
Circle=start/end, Rectangle=activity, Diamond=decision, Arrow=flow.
Question:
17. Swimlanes
Answer:
Divides process diagram into lanes by role or department.
Question:
18. Artificial Intelli-gence (AI)
Answer:
Computers performing tasks needing human intelligence; uses machine learn-ing.
