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. An ERM is not dependent on the ____________.
Dependency Diagram
Database type
2NF
Surrogate
2. 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.
Surrogate
Derived attribute
Binary
Participation
3. A ___ relationship exists when an association is maintained within a single entity.
Unary
Data warehouse
Composite
Duplication
4. A ____ relationship exists when three entities are associated.
Derived
Associative
Data warehouse
Ternary
5. The set of possible values for an attribute is a ____.
Domain
Strong
Multivalued dependencies
3NF
6. A ___________ must not contain a repeating group .
Simple
Relational table
Ternary
Binary
7. 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.
Composite
Binary
RDBMS
Database type
8. __________ is a process to help reduce the likelihood of data anomalies.
Normalization
Composite
Granularity
Data redundancy
9. From a structural point of view - ______ is better than 1NF
2NF
3NF
BCNF
Recursive
10. A _____ entity is composed of the primary keys of each of the entities to be connected.
Determinant
Associative
Information requirements
Derived
11. _______ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Data warehouse
Repeating group
Derived
Data redundancy
12. If you have three different transitive dependencies - ___ different determinants exist.
Temporary
Three
Determinant
Dependency Diagram
13. The price paid for increased performance through denormalization is a larger amount of ____.
Candidate key
Data redundancy
ERM
Single-valued
14. A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Unary
BCNF
Weak
Participation
15. 1NF - 2NF - and 3NF are _____.
(1 - 1)
Normalization stages
Duplication
Recursive
16. Refers to the level of detail represented by the values stored in a table's row
Granularity
Database design
Candidate key
Derived attribute
17. Any attribute whose value determines other values within a row is called ____.
Associative
Determinant
Performance
Single-valued
18. A ___ attribute is one that cannot be subdivided.
Detailed narrative
Domain
Atomic attribute
Simple
19. A table is in BCNF if every determinant in the table is a ____________.
Atomic attribute
Dependency Diagram
Dependency
Candidate key
20. 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.
Participation
Simple
Ternary
Transitive dependency
21. A ___ relationship exists when two entities are associated.
Data integrity problems
Candidate
Binary
Numeric
22. A talbe is in 4NF if it is 3NF and has no ________.
Transitive dependency
3NF
Relational table
Multivalued dependencies
23. When a nonkey attribute is the determinate of a key attribute the table is in 3NF but not ____.
Recursive
Dependency
BCNF
Information requirements
24. ____ yields better performance.
3NF
Mandatory
Unary
Denormalization
25. Need not be stored physically in the data base.
Single-valued
Three
Data integrity problems
Derived attribute
26. 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.
Performance
Composite
Temporary
Normalization stages
27. 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
Entities
Recursive
Granularity
28. An attribute that is part of a key is known as a ____ attribute.
4NF
JOB_CHG_HOUR
Prime
Derived attribute
29. Most designers consider the BCNF as a special case of the ____.
Relational models
3NF
Derived attribute
Atomicity
30. 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.
Data integrity problems
Repeating group
Surrogate
Atomicity
31. From a system functionality point of view - ___ attribute values can be calculated when they are needed to write reports or invoices.
Determinant
Information requirements
Granularity
Derived
32. For most business transactional databases - we should normalize relations into ____.
Domain
Partial
Atomicity
3NF
33. A ______ attribute can have only one value.
Single-valued
Table
Determinant
(1 - 1)
34. In order to meet performance requirements - you may have to denormalize portions of the ________.
Database design
Relational table
Candidate
Database type
35. Depicts all dependencies found within a given table structure is known as a ______.
Unary
Table
Transitive dependency
Dependency Diagram
36. 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
Granularity
Normalization
Information
37. The ___ refers to a specific table row as an entity instance.
Ternary
3NF
Determinant
ERM
38. Another word for existence-independent is ____.
(min - max)
Three
Strong
Composite
39. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
Prime
Determinant
Dependency
(1 - 1)
40. In order to meet ___ requirements - you may have to denormalize some portion of the database.
Granularity
Performance
Atomic attribute
Surrogate
41. Data redundancies occur from ____ of data on every row entry.
Repeating group
Denormalization
Duplication
Transitive dependency
42. 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.
Atomicity
Mandatory
Repeating group
Information requirements
43. Normalization represents a micro view of the ___ within the ERD.
Entities
Unary
Relational table
3NF
44. The associative entity is also known as a ___ entity.
Associative
Data redundancy
Database type
Composite
45. The following step occurs first in the process of building an ERD: create a __________ of the organization's description of operations.
RDBMS
Composite
Detailed narrative
Associative
46. View the data as part of a table or collection of tables in which all key values must be identified.
Relational models
Partial dependencies
Temporary
Multivalued dependencies
47. 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.
Domain
Normalization stages
Partial dependencies
Repeating group
48. Complex ____ requirements may dictate data transformations - and they may expand the number of entities and attributes withing the design.
Numeric
Weak
Information
Associative
49. ________ cannot be further subdivided.
Partial dependencies
BCNF
Atomic attribute
Candidate
50. The Crow's foot symbol with two parallel lines indicates ___ cardinality.
Information requirements
(1 - 1)
Atomicity
Derived attribute