RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Relational Data Analysis
Relational Constraints
DB Normal Forms
Third Normal Form
Table Joins User Views
Second Normal Form - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
What process does the technical term normalization describe?
Please select the best answer.
A.
Creating tables from an ER diagram
B.
Creating larger tables from smaller tables
C.
Expressing a database's design in terms of set theory
D.
Breaking larger tables into smaller tables
2.
What kind of inefficiencies may exist in tables that have not been normalized?
Please select all the correct answers.
A.
Redundant data
B.
Lengthy updates
C.
Slow searches and queries
D.
Missing data
3.
To what does the term normal form refer?
Please select the best answer.
A.
A stage in a process that breaks up large tables into smaller, more efficient tables
B.
A standard database included with most RDBMSs
C.
A standard table included with most RDBMSs
D.
A methodology for representing tables in an ER diagram
