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