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