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