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