SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
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. Need not be stored physically in the data base.
BCNF
Derived attribute
Surrogate
Determinant
2. Depicts all dependencies found within a given table structure is known as a ______.
Mandatory
Diagram
Detailed narrative
Dependency Diagram
3. For most business transactional databases - we should normalize relations into ____.
3NF
2NF
Atomicity
Normalization stages
4. From a system functionality point of view - ___ attribute values can be calculated when they are needed to write reports or invoices.
Data redundancy
Derived
Unary
BCNF
5. ______________database tables often lead to various data redundancy disasters in production databases.
Mandatory
Single-valued
Unnormalized
Strong
6. An attribute that is part of a key is known as a ____ attribute.
Domain
Prime
4NF
Data integrity problems
7. An ERM is not dependent on the ____________.
Unnormalized
Candidate key
(1 - 1)
Database type
8. __________ is a process to help reduce the likelihood of data anomalies.
3NF
Dependency
4NF
Normalization
9. 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.
Repeating group
Recursive
Transitive dependency
Normalization
10. The following step occurs first in the process of building an ERD: create a __________ of the organization's description of operations.
Detailed narrative
RDBMS
Partial
Composite
11. Complex ____ requirements may dictate data transformations - and they may expand the number of entities and attributes withing the design.
Information
Composite
Normalization stages
2NF
12. The conflicts between design efficiency - ____________ - and processing speed are often resolved through compromised that include denormalization.
3NF
Atomic attribute
Denormalization
Information requirements
13. The Crow's foot symbol with two parallel lines indicates ___ cardinality.
Determinant
RDBMS
Dependency
(1 - 1)
14. Another word for existence-independent is ____.
Ternary
Strong
Performance
Entities
15. The existence of a(n) ___ relationship indicated that the minimum cardinality is at least 1 for the mandatory entity.
Weak
Entities
Mandatory
Composite
16. A _____ entity is composed of the primary keys of each of the entities to be connected.
Determinant
Temporary
Associative
3NF
17. 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 ____.
4NF
Diagram
Database design
Normalization stages
18. A talbe is in 4NF if it is 3NF and has no ________.
Simple
Data redundancy
Weak
Multivalued dependencies
19. Dependencies can be identified with the help of a dependency _____.
BCNF
Diagram
Relational table
Partial
20. Data redundancies occur from ____ of data on every row entry.
Duplication
Dependency
Composite
Repeating group
21. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
Determinant
Dependency
Atomic attribute
3NF
22. A ____ relationship exists when three entities are associated.
Normalization stages
Information
Ternary
Candidate key
23. Dependencies based on only a part of a composite primary key are called ___ dependencies.
Composite
Temporary
Partial
Weak
24. A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Information
(1 - 1)
Normalization
Weak
25. 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.
Partial
Strong
RDBMS
Simple
26. The word "entity" in the ER model corresponds to a _______.
Table
Denormalization
ERM
Normalization stages
27. 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
Partial
Atomic attribute
Prime
28. ____ yields better performance.
Three
RDBMS
Relational models
Denormalization
29. 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.
2NF
Diagram
BCNF
Temporary
30. A table is in BCNF if every determinant in the table is a ____________.
Composite
Domain
Candidate key
Duplication
31. A table that is in 2NF and contains no transitive dependencies is said to be in ___.
3NF
Partial dependencies
Normalization
Numeric
32. When a nonkey attribute is the determinate of a key attribute the table is in 3NF but not ____.
BCNF
Multivalued dependencies
Information requirements
Surrogate
33. A ___ relationship exists when an association is maintained within a single entity.
Mandatory
Database type
Atomic attribute
Unary
34. A ___ relationship exists when two entities are associated.
(1 - 1)
BCNF
Dependency
Binary
35. BCNF can be violated only if the table contains more than one ___ key.
Three
Candidate
Granularity
Numeric
36. Any attribute whose value determines other values within a row is called ____.
Domain
Determinant
Denormalization
Participation
37. A ___________ must not contain a repeating group .
Data warehouse
Relational table
Diagram
Partial dependencies
38. In order to meet performance requirements - you may have to denormalize portions of the ________.
Surrogate
Data warehouse
Database design
RDBMS
39. In the ERD - Cardinality is indicated using the ___ notation.
BCNF
(min - max)
Single-valued
(1 - 1)
40. Data redundancy produces ____.
Data integrity problems
Derived attribute
Determinant
Relational table
41. The price paid for increased performance through denormalization is a larger amount of ____.
Relational table
Data redundancy
Associative
Atomicity
42. In order to meet ___ requirements - you may have to denormalize some portion of the database.
Relational models
Participation
Performance
Partial dependencies
43. 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.
Weak
Participation
Diagram
Single-valued
44. 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 ____.
Mandatory
1NF
Unnormalized
BCNF
45. The ___ refers to a specific table row as an entity instance.
Numeric
Repeating group
ERM
Data redundancy
46. The set of possible values for an attribute is a ____.
Domain
Database design
(1 - 1)
Multivalued dependencies
47. 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.
Derived
Participation
Three
Surrogate
48. ________ cannot be further subdivided.
Performance
Atomic attribute
Data warehouse
BCNF
49. 1NF - 2NF - and 3NF are _____.
Normalization
Granularity
Duplication
Normalization stages
50. Normalization represents a micro view of the ___ within the ERD.
Entities
Mandatory
Strong
Participation