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. 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 ____.
2NF
Recursive
1NF
Unary
2. A _____ entity is composed of the primary keys of each of the entities to be connected.
Simple
Strong
Associative
Information requirements
3. The associative entity is also known as a ___ entity.
Partial dependencies
Composite
JOB_CHG_HOUR
Denormalization
4. Refers to the level of detail represented by the values stored in a table's row
Three
Granularity
Recursive
Data redundancy
5. When a nonkey attribute is the determinate of a key attribute the table is in 3NF but not ____.
BCNF
JOB_CHG_HOUR
Information requirements
3NF
6. The word "entity" in the ER model corresponds to a _______.
Weak
3NF
1NF
Table
7. A ____ relationship exists when three entities are associated.
Composite
Ternary
Relational table
Determinant
8. The price paid for increased performance through denormalization is a larger amount of ____.
3NF
Database type
Data redundancy
Atomicity
9. Data redundancies occur from ____ of data on every row entry.
Composite
Composite
Participation
Duplication
10. Complex ____ requirements may dictate data transformations - and they may expand the number of entities and attributes withing the design.
Determinant
Recursive
Information
Atomicity
11. A table that is in 2NF and contains no transitive dependencies is said to be in ___.
Denormalization
Determinant
3NF
(1 - 1)
12. View the data as part of a table or collection of tables in which all key values must be identified.
4NF
Relational models
Ternary
Repeating group
13. ____ yields better performance.
Diagram
JOB_CHG_HOUR
Composite
Denormalization
14. Most designers consider the BCNF as a special case of the ____.
3NF
Numeric
Mandatory
RDBMS
15. A ___ attribute is one that cannot be subdivided.
Simple
3NF
Surrogate
Partial
16. Need not be stored physically in the data base.
Derived attribute
Granularity
Weak
Normalization stages
17. If an employee within an EMPLOYEE entity has a relationship with itself - that relationship is known as a ____ relationship.
Three
Recursive
Repeating group
Determinant
18. Normalization represents a micro view of the ___ within the ERD.
Entities
Relational table
Single-valued
Normalization
19. 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.
Unary
Granularity
RDBMS
1NF
20. From a structural point of view - ______ is better than 1NF
2NF
ERM
Candidate key
Participation
21. 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
Atomicity
Relational table
Surrogate
22. 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.
Candidate key
2NF
Multivalued dependencies
Participation
23. The set of possible values for an attribute is a ____.
Dependency
Binary
Domain
Granularity
24. A table where every determinant is a candidate key is said to be in ____.
Performance
BCNF
Single-valued
Table
25. A ___ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
Associative
Three
Weak
Atomicity
26. Data redundancy produces ____.
Single-valued
Domain
Entities
Data integrity problems
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.
Relational table
Repeating group
Transitive dependency
Table
28. 1NF - 2NF - and 3NF are _____.
Normalization stages
Single-valued
Prime
Dependency Diagram
29. Another word for existence-independent is ____.
Relational table
Three
RDBMS
Strong
30. A ___________ must not contain a repeating group .
Ternary
Associative
Three
Relational table
31. An attribute that is part of a key is known as a ____ attribute.
Multivalued dependencies
2NF
Numeric
Prime
32. A table is in BCNF if every determinant in the table is a ____________.
Partial
Composite
Candidate key
Determinant
33. If you have three different transitive dependencies - ___ different determinants exist.
Three
Candidate
Data redundancy
Table
34. In order to meet ___ requirements - you may have to denormalize some portion of the database.
Denormalization
Entities
Performance
Relational table
35. The Crow's foot symbol with two parallel lines indicates ___ cardinality.
Composite
Data redundancy
Transitive dependency
(1 - 1)
36. Dependencies based on only a part of a composite primary key are called ___ dependencies.
Performance
Partial
Ternary
Domain
37. 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.
Multivalued dependencies
Candidate
Temporary
Ternary
38. 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.
Numeric
Dependency
JOB_CHG_HOUR
Candidate key
39. A ___ relationship exists when an association is maintained within a single entity.
Unary
Data redundancy
Table
Surrogate
40. _______ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
Binary
Data warehouse
Data integrity problems
Candidate key
41. Dependencies can be identified with the help of a dependency _____.
2NF
Normalization
Recursive
Diagram
42. The conflicts between design efficiency - ____________ - and processing speed are often resolved through compromised that include denormalization.
Performance
Partial
Information requirements
Domain
43. An ERM is not dependent on the ____________.
Entities
Derived attribute
Data redundancy
Database type
44. A ______ attribute can have only one value.
3NF
Single-valued
Performance
3NF
45. THE MOST LIKELY DATA TYPE FOR A SURROGATE KEY IS ____.
Numeric
Binary
Data integrity problems
Composite
46. A talbe is in 4NF if it is 3NF and has no ________.
Strong
Database type
Multivalued dependencies
(1 - 1)
47. A ___ relationship exists when two entities are associated.
Binary
Detailed narrative
Denormalization
Dependency Diagram
48. In a ___ diagram - the arrows above the attribute indicate all desirable dependencies.
Domain
Dependency
Performance
Three
49. The existence of a(n) ___ relationship indicated that the minimum cardinality is at least 1 for the mandatory entity.
4NF
Numeric
Binary
Mandatory
50. From a system functionality point of view - ___ attribute values can be calculated when they are needed to write reports or invoices.
Derived attribute
3NF
Derived
Entities
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests