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