DATA MANAGEMENT FOUNDATIONS UPDATED ACTUAL EXAM QUESTIONS CORRECT
ANSWERS GRADED A PLUS
Question:
Define: Referential Integrity.
Answer:
Requires that ALL foreign key values must either be fully NULL or match some primary key value.
Question:
4 Ways Referential Integrity can be violated.
Answer:
1. Primary key is updated 2. Foreign key is updated 3. Row containing primary key is DELETED 4.
Row containing foreign key is INSERTED.
Question:
Actions to Correct Referential Integrity Violation.
Answer:
1. RESTRICT - rejects an insert, update, or delete 2. SET NULL - sets invalid foreign keys to null 3.
SET DEFAULT - sets invalid foreign keys to a default primary value 4. CASCADE - propagates
primary key changes to foreign keys.
Question:
What is an Important aspect of Referential Integrity.
Answer:
Reference to data in one relation is based on values in another relation.
,Question:
What is Broad definition of data.
Answer:
Raw facts captured on printed or digital media.
Question:
What Data.
Answer:
Facts that are collected and stored in a database system.
Question:
Determining characteristic of unstructured data.
Answer:
It does not follow a data model.
Question:
Flat files.
Answer:
They contain no internal hierarchical organization.
Question:
Data retrieval before database management systems.
Answer:
Sequentially from simple files.
Question:
,Primary Key.
Answer:
An attribute or group of attributes that uniquely identify a tuple in a relation.
Question:
Foreign Key matching.
Answer:
A domain of values is necessary for a primary key in one relation of a database to match with its
corresponding foreign key in another relation of the same database.
Question:
Alternate Key.
Answer:
What uniquely identifies each entity in a collection of entities but is not the primary key.
Question:
Candidate Key.
Answer:
A set of columns in a table that can uniquely identify any record in that table without referring to
other data.
Question:
Database indexing.
Answer:
The original data is copied to the index.
Question:
, Indexes in physical database design.
Answer:
To retrieve data DIRECTLY using a pointer.
Question:
Index creation on a database column.
Answer:
To optimize data retrievals.
Question:
Functional Dependency.
Answer:
Each value of a column relates to at MOST one value of another column.
Question:
Rules/Appearance of First Normal Form.
Answer:
- All non-key columns depend on primary key - Each table cell contains one value A table with no
duplicate rows.
Question:
Rules/Appearance of Second Normal Form.
Answer:
- When all non-key columns depend on the WHOLE primary key - Must be in 1NF - Non-key
column can not depend on just one part of a composite key - a single primary key is automatically in
2NF.
ANSWERS GRADED A PLUS
Question:
Define: Referential Integrity.
Answer:
Requires that ALL foreign key values must either be fully NULL or match some primary key value.
Question:
4 Ways Referential Integrity can be violated.
Answer:
1. Primary key is updated 2. Foreign key is updated 3. Row containing primary key is DELETED 4.
Row containing foreign key is INSERTED.
Question:
Actions to Correct Referential Integrity Violation.
Answer:
1. RESTRICT - rejects an insert, update, or delete 2. SET NULL - sets invalid foreign keys to null 3.
SET DEFAULT - sets invalid foreign keys to a default primary value 4. CASCADE - propagates
primary key changes to foreign keys.
Question:
What is an Important aspect of Referential Integrity.
Answer:
Reference to data in one relation is based on values in another relation.
,Question:
What is Broad definition of data.
Answer:
Raw facts captured on printed or digital media.
Question:
What Data.
Answer:
Facts that are collected and stored in a database system.
Question:
Determining characteristic of unstructured data.
Answer:
It does not follow a data model.
Question:
Flat files.
Answer:
They contain no internal hierarchical organization.
Question:
Data retrieval before database management systems.
Answer:
Sequentially from simple files.
Question:
,Primary Key.
Answer:
An attribute or group of attributes that uniquely identify a tuple in a relation.
Question:
Foreign Key matching.
Answer:
A domain of values is necessary for a primary key in one relation of a database to match with its
corresponding foreign key in another relation of the same database.
Question:
Alternate Key.
Answer:
What uniquely identifies each entity in a collection of entities but is not the primary key.
Question:
Candidate Key.
Answer:
A set of columns in a table that can uniquely identify any record in that table without referring to
other data.
Question:
Database indexing.
Answer:
The original data is copied to the index.
Question:
, Indexes in physical database design.
Answer:
To retrieve data DIRECTLY using a pointer.
Question:
Index creation on a database column.
Answer:
To optimize data retrievals.
Question:
Functional Dependency.
Answer:
Each value of a column relates to at MOST one value of another column.
Question:
Rules/Appearance of First Normal Form.
Answer:
- All non-key columns depend on primary key - Each table cell contains one value A table with no
duplicate rows.
Question:
Rules/Appearance of Second Normal Form.
Answer:
- When all non-key columns depend on the WHOLE primary key - Must be in 1NF - Non-key
column can not depend on just one part of a composite key - a single primary key is automatically in
2NF.
