RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
Physical Design
«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
Vertically Partitioning Table - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Vertically partitioning a table creates what change to the table?
Please select the best answer.
A.
The table's rows are stored in two or more smaller tables.
B.
The table's columns are stored in two or more smaller tables, linked by the original table's primary key fields.
C.
The table's columns are combined with columns from another table.
D.
The table's rows are combined with rows from another table.
2.
Horizontally partitioning a table can result in what performance trade-offs?
Please select all the correct answers.
A.
Finding records in more than one partition is faster than if the records were in a single, larger table.
B.
Finding records in more than one partition is slower than if the records were in a single, larger table.
C.
Finding records in a single partition is faster than if the records were in a single, larger table.
D.
Finding records in a single partition is slower than if the records were in a single, larger table.
3.
Vertically partitioning a table slows down what operations?
Please select all the correct answers.
A.
Joins based on frequently joined fields
B.
Inserting new records
C.
Searching complete records
D.
Deleting records