SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Data Modeling
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A _____ entity is composed of the primary keys of each of the entities to be connected.
Data warehouse
Denormalization
Information
Associative
2. Dependencies can be identified with the help of a dependency _____.
Ternary
Information requirements
Diagram
4NF
3. ______________database tables often lead to various data redundancy disasters in production databases.
Table
Database type
Unnormalized
Relational table
4. Normalization represents a micro view of the ___ within the ERD.
Entities
Mandatory
Dependency Diagram
BCNF
5. __________ is a process to help reduce the likelihood of data anomalies.
Derived
3NF
Mandatory
Normalization
6. If you have three different transitive dependencies - ___ different determinants exist.
Partial dependencies
Determinant
Three
Single-valued
7. A table is in BCNF if every determinant in the table is a ____________.
Candidate key
4NF
Detailed narrative
Data warehouse
8. An example of denormalization is using a ___ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that is stored in the table as rows.
Derived attribute
Atomicity
Temporary
Data integrity problems
9. Refers to the level of detail represented by the values stored in a table's row
ERM
Entities
Granularity
Duplication
10. Another word for existence-independent is ____.
Derived attribute
Strong
Partial dependencies
BCNF
11. A ___ attribute is one that cannot be subdivided.
Transitive dependency
Simple
Unary
Composite
12. An attribute that is part of a key is known as a ____ attribute.
Derived attribute
Performance
Partial dependencies
Prime
13. A ____ relationship exists when three entities are associated.
Ternary
(min - max)
Strong
Relational table
14. Complex ____ requirements may dictate data transformations - and they may expand the number of entities and attributes withing the design.
BCNF
Information
Data redundancy
Data warehouse
15. Most designers consider the BCNF as a special case of the ____.
1NF
Multivalued dependencies
3NF
Relational table
16. A table that is in 2NF and contains no transitive dependencies is said to be in ___.
Single-valued
Multivalued dependencies
3NF
Participation
17. A table where all attributes are dependent on the primary key are independent of each other - and no row contains two or more multivalued facts about an entity - is said to be in ____.
4NF
1NF
Repeating group
(min - max)
18. The ___ refers to a specific table row as an entity instance.
Database type
Relational models
Duplication
ERM
19. Need not be stored physically in the data base.
RDBMS
Derived attribute
Mandatory
Candidate
20. ____ yields better performance.
Derived
Partial dependencies
Denormalization
Determinant
21. The conflicts between design efficiency - ____________ - and processing speed are often resolved through compromised that include denormalization.
Information requirements
Unary
Detailed narrative
Data integrity problems
22. Relationship strength depends on how the primary key of the related entity is formulated - while the relationship ____ depends on how the business rule is written.
Weak
Participation
4NF
3NF
23. In order to meet performance requirements - you may have to denormalize portions of the ________.
Normalization stages
Database design
Participation
Single-valued
24. In the ERD - Cardinality is indicated using the ___ notation.
(min - max)
Strong
Atomicity
Temporary
25. _______ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Three
Data warehouse
Multivalued dependencies
Recursive
26. THE MOST LIKELY DATA TYPE FOR A SURROGATE KEY IS ____.
Numeric
Repeating group
Composite
1NF
27. A table where every determinant is a candidate key is said to be in ____.
Granularity
BCNF
(min - max)
Relational models
28. From a system functionality point of view - ___ attribute values can be calculated when they are needed to write reports or invoices.
Binary
Entities
4NF
Derived
29. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
BCNF
Dependency
Database design
Normalization
30. The Crow's foot symbol with two parallel lines indicates ___ cardinality.
Data redundancy
(1 - 1)
Transitive dependency
Table
31. The price paid for increased performance through denormalization is a larger amount of ____.
Determinant
Data warehouse
Data redundancy
Candidate key
32. A ____ exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y - and X is the primary key.
BCNF
Data integrity problems
Transitive dependency
Partial dependencies
33. If an employee within an EMPLOYEE entity has a relationship with itself - that relationship is known as a ____ relationship.
Information
JOB_CHG_HOUR
Recursive
Ternary
34. View the data as part of a table or collection of tables in which all key values must be identified.
Database type
Relational models
Recursive
Mandatory
35. In order to meet ___ requirements - you may have to denormalize some portion of the database.
BCNF
Performance
Unnormalized
Mandatory
36. The associative entity is also known as a ___ entity.
Entities
Composite
RDBMS
ERM
37. A ___ identifier is composed of more than one attribute.
ERM
Table
Composite
Binary
38. If a table has multiple candidate keys and one of those candidate keys is a composite key - the table can have ___ based on this composite candidate key - even when the primary key chosen is a single attribute.
RDBMS
Weak
Partial dependencies
Participation
39. 1NF - 2NF - and 3NF are _____.
Normalization stages
Entities
BCNF
Denormalization
40. A ___________ must not contain a repeating group .
BCNF
Diagram
Relational table
Strong
41. Any attribute whose value determines other values within a row is called ____.
Determinant
3NF
Composite
ERM
42. The word "entity" in the ER model corresponds to a _______.
Table
BCNF
Repeating group
Ternary
43. The following step occurs first in the process of building an ERD: create a __________ of the organization's description of operations.
Duplication
Mandatory
Detailed narrative
Data integrity problems
44. A table that has all key attributes defined - has no repeating groups - and all its attributes are dependent on the primary key - is said to be in ____.
1NF
Single-valued
Prime
Data redundancy
45. A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Associative
Unnormalized
Weak
Diagram
46. Data redundancies occur from ____ of data on every row entry.
Participation
Partial
Recursive
Duplication
47. According to naming conventions described in Chapter 2 - ___ would be the best name for a column representing the charges per hour in a table named JOB.
Unnormalized
Diagram
1NF
JOB_CHG_HOUR
48. The set of possible values for an attribute is a ____.
Dependency Diagram
Domain
Performance
Unnormalized
49. In a real-world environment - changing granularity requirements might dictate changes in primary key selection - and those changes might ultimately require the use of ____ keys.
Strong
Information requirements
Surrogate
Information
50. A ___ relationship exists when two entities are associated.
Table
Relational table
Binary
Atomic attribute