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