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