RelationalDBDesign
RelationalDBDesign
SiteMap
Database Analysis
Database Design
Relational Constructs
«Prev
Next»
Data Analysis
Relational Constraints
DB Life Cycle
Table Characteristics
Database Null Values
Primary Key
Concatenated Keys
Defining Foreign Keys
Referential Integrity
Normal Forms
1st NF Limitations
Reduce Data Redundancy
Normalization - Quiz
Third Normal Form
1st, 2nd, 3rd NF
Joins, User Views
Permissions Design Role
SQL Joining Tables
Permissions Requirements Analysis
SQL Inner Join
Physical Design
Disadvantages Horizontal Partitioning
Disadvantages Vertical Partitioning
Horizontal Partition
Database Vertical Partitioning
DB Design Mistakes
Business Objects Rules
Common Mistakes
Primary Foreign Key Mistakes
Relational Constructs Database Table - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
A table field that is a primary-key field in another table is referred to as what kind of key?
Please select the best answer.
A.
Concatenated primary key
B.
Foreign key
C.
Candidate key
D.
Primary key
2.
Which of the following data domains support calculations?
Please select all the correct answers.
A.
VARCHAR
B.
BOOLEAN
C.
INT
D.
DATE
3.
A descriptor column contains what type of data?
Please select the best answer.
A
A description of the table as a whole
B.
A candidate key
C.
A non-key attribute of an entity
D.
A link to another table
4.
If you knew a company had a fax number but didn't have it on hand, what type of value would you use as a placeholder in that table column?
Please select the best answer.
A.
A zero
B.
A blank
C.
A null
D.
A single letter