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