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