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. 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.
Multivalued dependencies
Participation
BCNF
(1 - 1)
2. 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.
Surrogate
Performance
Data integrity problems
Repeating group
3. _______ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Determinant
(min - max)
Data warehouse
Derived
4. The conflicts between design efficiency - ____________ - and processing speed are often resolved through compromised that include denormalization.
Three
Surrogate
Duplication
Information requirements
5. The following step occurs first in the process of building an ERD: create a __________ of the organization's description of operations.
Detailed narrative
Temporary
Derived
Relational models
6. 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.
Entities
RDBMS
Performance
Normalization
7. A ___ relationship exists when an association is maintained within a single entity.
Three
Unary
Surrogate
Data warehouse
8. If you have three different transitive dependencies - ___ different determinants exist.
ERM
Three
Multivalued dependencies
Numeric
9. 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.
RDBMS
Duplication
Data redundancy
Repeating group
10. The ___ refers to a specific table row as an entity instance.
3NF
Single-valued
ERM
Mandatory
11. Dependencies can be identified with the help of a dependency _____.
Numeric
Unary
Diagram
Weak
12. ____ yields better performance.
Weak
Relational models
Denormalization
Candidate key
13. In order to meet ___ requirements - you may have to denormalize some portion of the database.
Performance
Partial
Dependency Diagram
Information requirements
14. 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
Diagram
Information requirements
Duplication
15. 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.
Derived
Table
Data integrity problems
Partial dependencies
16. The word "entity" in the ER model corresponds to a _______.
(1 - 1)
3NF
Denormalization
Table
17. 1NF - 2NF - and 3NF are _____.
Determinant
Normalization stages
Single-valued
Entities
18. Data redundancy produces ____.
Data integrity problems
Composite
JOB_CHG_HOUR
Normalization stages
19. THE MOST LIKELY DATA TYPE FOR A SURROGATE KEY IS ____.
1NF
Numeric
Atomic attribute
Repeating group
20. A ___________ must not contain a repeating group .
Relational table
Table
Associative
JOB_CHG_HOUR
21. Normalization represents a micro view of the ___ within the ERD.
Partial dependencies
BCNF
Entities
Dependency Diagram
22. From a structural point of view - ______ is better than 1NF
3NF
Recursive
Granularity
2NF
23. A ___ attribute is one that cannot be subdivided.
Simple
Unary
Determinant
Ternary
24. Improving ___ leads to more flexible queries.
Ternary
Atomicity
Strong
3NF
25. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
Data warehouse
BCNF
Dependency
Derived attribute
26. Another word for existence-independent is ____.
Strong
Data redundancy
Partial dependencies
Candidate key
27. A ___ relationship exists when two entities are associated.
Derived
Atomicity
Binary
Repeating group
28. A ______ attribute can have only one value.
Single-valued
Prime
Derived attribute
Partial
29. A ___ identifier is composed of more than one attribute.
Numeric
(min - max)
Composite
4NF
30. From a system functionality point of view - ___ attribute values can be calculated when they are needed to write reports or invoices.
Derived
Derived attribute
ERM
Unnormalized
31. Depicts all dependencies found within a given table structure is known as a ______.
Dependency Diagram
Prime
JOB_CHG_HOUR
2NF
32. Data redundancies occur from ____ of data on every row entry.
Duplication
Single-valued
Composite
Database design
33. Most designers consider the BCNF as a special case of the ____.
Relational models
3NF
Composite
Domain
34. Refers to the level of detail represented by the values stored in a table's row
Recursive
Partial dependencies
BCNF
Granularity
35. ______________database tables often lead to various data redundancy disasters in production databases.
Derived attribute
Associative
Unnormalized
Partial dependencies
36. In the ERD - Cardinality is indicated using the ___ notation.
Diagram
Binary
(min - max)
Multivalued dependencies
37. A _____ entity is composed of the primary keys of each of the entities to be connected.
JOB_CHG_HOUR
Associative
Detailed narrative
BCNF
38. A ____ relationship exists when three entities are associated.
Numeric
4NF
Ternary
Data integrity problems
39. The price paid for increased performance through denormalization is a larger amount of ____.
Binary
Relational models
Data redundancy
3NF
40. 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
Relational models
Dependency
Transitive dependency
41. __________ is a process to help reduce the likelihood of data anomalies.
1NF
Normalization
Data warehouse
Information requirements
42. An attribute that is part of a key is known as a ____ attribute.
2NF
Binary
Prime
Repeating group
43. 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.
Mandatory
Dependency Diagram
Transitive dependency
4NF
44. A talbe is in 4NF if it is 3NF and has no ________.
Three
Diagram
Recursive
Multivalued dependencies
45. The existence of a(n) ___ relationship indicated that the minimum cardinality is at least 1 for the mandatory entity.
Mandatory
Information requirements
Derived attribute
Diagram
46. A table where every determinant is a candidate key is said to be in ____.
Simple
BCNF
Table
Relational models
47. ________ cannot be further subdivided.
Relational models
Table
Atomic attribute
Data integrity problems
48. 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
Partial dependencies
Granularity
3NF
49. View the data as part of a table or collection of tables in which all key values must be identified.
Binary
Relational models
Table
Transitive dependency
50. When a nonkey attribute is the determinate of a key attribute the table is in 3NF but not ____.
1NF
BCNF
Associative
Derived