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 ___ identifier is composed of more than one attribute.
Composite
BCNF
Unnormalized
3NF
2. The set of possible values for an attribute is a ____.
ERM
Data integrity problems
Domain
Data redundancy
3. Depicts all dependencies found within a given table structure is known as a ______.
Table
Granularity
BCNF
Dependency Diagram
4. ____ yields better performance.
Information
Three
Denormalization
Data redundancy
5. Refers to the level of detail represented by the values stored in a table's row
Denormalization
(min - max)
Granularity
Single-valued
6. The ___ refers to a specific table row as an entity instance.
Atomicity
Transitive dependency
Multivalued dependencies
ERM
7. A ______ attribute can have only one value.
Single-valued
(1 - 1)
Binary
Derived
8. Another word for existence-independent is ____.
Prime
Repeating group
Participation
Strong
9. 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 ____.
Unary
Relational models
1NF
BCNF
10. A ___________ must not contain a repeating group .
Relational table
Database design
3NF
Granularity
11. An attribute that is part of a key is known as a ____ attribute.
Prime
Repeating group
Atomic attribute
Database type
12. A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Weak
Relational table
Data redundancy
1NF
13. When a nonkey attribute is the determinate of a key attribute the table is in 3NF but not ____.
Unnormalized
BCNF
Recursive
Weak
14. 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.
Strong
1NF
Transitive dependency
Unary
15. Improving ___ leads to more flexible queries.
Three
3NF
Database design
Atomicity
16. Complex ____ requirements may dictate data transformations - and they may expand the number of entities and attributes withing the design.
Information
Partial
Three
Unnormalized
17. __________ is a process to help reduce the likelihood of data anomalies.
Normalization
Performance
Determinant
Atomic attribute
18. For most business transactional databases - we should normalize relations into ____.
Detailed narrative
Numeric
Data warehouse
3NF
19. The associative entity is also known as a ___ entity.
Data integrity problems
Composite
Mandatory
2NF
20. If database tables are treated as though they were files in a file system - the ___ never has a chance to demonstrate its superior data-handling capabilities.
(min - max)
3NF
3NF
RDBMS
21. The conflicts between design efficiency - ____________ - and processing speed are often resolved through compromised that include denormalization.
Detailed narrative
Information requirements
Partial dependencies
Participation
22. A ___ attribute is one that cannot be subdivided.
Binary
Simple
Ternary
Normalization
23. ________ cannot be further subdivided.
RDBMS
Binary
Duplication
Atomic attribute
24. A ___ relationship exists when an association is maintained within a single entity.
Composite
Recursive
Unary
Surrogate
25. Normalization represents a micro view of the ___ within the ERD.
Unary
Determinant
4NF
Entities
26. If you have three different transitive dependencies - ___ different determinants exist.
Determinant
Three
Entities
Performance
27. A ____ relationship exists when three entities are associated.
ERM
Candidate key
Ternary
Partial
28. Most designers consider the BCNF as a special case of the ____.
3NF
Atomic attribute
4NF
Normalization stages
29. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
Partial dependencies
Single-valued
Dependency
Denormalization
30. 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.
Unary
Partial
Derived
Partial dependencies
31. A table is in BCNF if every determinant in the table is a ____________.
Data redundancy
Candidate key
Recursive
Candidate
32. In order to meet performance requirements - you may have to denormalize portions of the ________.
Database design
Numeric
4NF
Data warehouse
33. If an employee within an EMPLOYEE entity has a relationship with itself - that relationship is known as a ____ relationship.
Surrogate
Database design
(min - max)
Recursive
34. Any attribute whose value determines other values within a row is called ____.
Repeating group
Determinant
Recursive
Information requirements
35. Need not be stored physically in the data base.
Detailed narrative
BCNF
BCNF
Derived attribute
36. BCNF can be violated only if the table contains more than one ___ key.
(min - max)
Detailed narrative
Candidate
BCNF
37. Data redundancies occur from ____ of data on every row entry.
Unnormalized
Duplication
Binary
Information
38. Data redundancy produces ____.
Relational models
Data integrity problems
Three
JOB_CHG_HOUR
39. A ___ relationship exists when two entities are associated.
Binary
Prime
Information requirements
Detailed narrative
40. The following step occurs first in the process of building an ERD: create a __________ of the organization's description of operations.
Denormalization
Database design
Detailed narrative
Derived attribute
41. A _____ entity is composed of the primary keys of each of the entities to be connected.
Dependency
Transitive dependency
Repeating group
Associative
42. 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
Dependency
Atomic attribute
Table
43. A ___ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Surrogate
Repeating group
Unnormalized
Ternary
44. Dependencies can be identified with the help of a dependency _____.
Diagram
4NF
Performance
Atomic attribute
45. In order to meet ___ requirements - you may have to denormalize some portion of the database.
Determinant
Performance
Duplication
Dependency
46. A talbe is in 4NF if it is 3NF and has no ________.
Atomic attribute
Derived attribute
Multivalued dependencies
Binary
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.
JOB_CHG_HOUR
Table
Ternary
Derived attribute
48. ______________database tables often lead to various data redundancy disasters in production databases.
Weak
1NF
Unnormalized
2NF
49. A table where every determinant is a candidate key is said to be in ____.
Simple
Ternary
BCNF
Database type
50. 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.
Three
Surrogate
Normalization
Recursive