RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
Database Analysis
«Prev
Next»
Data Analysis
Relational Constraints
DB Life Cycle
Relational Notation
Data Modeling
Table Characteristics
Database Characteristics
Table Column Rules
Table Row Rules
Columns Entity Attributes
Calculate Domain Types
RDBMS Calculations
Database Null Values
Null Zero Blank
Key Column Descriptors
Primary Key
Surrogate Keys
Concatenated Keys
Primary Foreign Key
Defining Foreign Keys
Referential Integrity
Relational Constructs Conclusion
Normal Forms
Reduce Data Redundancy
Normalization Defined
Normalization Objective
Normalization Process - Quiz
First Normal Form
Achieving First Normal
First NF Limitations
Second Normal Form
Define Functional Dependencies
Identify Functional Dependencies
Achieving 2nd Normal Form
Second NF Limitations
DB Normalization Conclusion
Normalization - Quiz
Third Normal Form
2NF Limitations
Transitive Dependencies
Eliminate Dependencies
Achieve 3rd Normal Form
1st, 2nd, 3rd NF
Codds Twelve Criteria
(BCNF) Four Important Rules
Codds Twelve Rules
Boyce Codd Normal Form
Denormalizing Tables
Joins, User Views
Permissions Design Role
SQL Joining Tables
Table Join Explanation
Create Equi Join
Permissions Requirements Analysis
SQL Inner Join
Physical Design
Physical DB Design
Create index SQL
Drawbacks Field Indexing
Database Clustering
Data Clustering Trade-off
Database Partitioning
Horizontal Partition
Drawbacks Horizontal Partitioning
DB Vertical Partitioning
Drawbacks Vertical Partitioning
Create DB via SQL
Create Table via SQL
Use SQL to Build DB
Data Dictionary Entries
Data Dictionary
Physical Design Conclusion
DB Design Mistakes
Business Objects Rules
Common Mistakes
Primary Foreign Key Mistakes
Database Table Joins - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
For a table join to produce meaningful information, the tables must be linked by what kind of fields?
Please select the best answer.
A.
Fields of the same name
B.
Fields with the same data domain
C.
Fields with equivalent data
D.
Fields that are both primary-key fields in their respective tables
2.
When you link two tables with an outer join, what character does the RDBMS use to fill in empty columns when a record has no matching record in the other table?
Please select the best answer.
A.
Blank
B.
Null
C.
Zero
D.
Question mark
3.
A view creates what type of tables for users to manipulate?
Please select the best answer.
A.
A joined table
B.
A base table
C.
A virtual table
D.
A linked table
4.
A view is stored as what type of database object?
Please select the best answer.
A.
A base table
B.
An SQL query
C.
A virtual table
D.
A relation
Correct answers:
Your Score: 0
Submit
Quiz Explanation