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
Database Normalization - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
A relation is in 1NF if it doesn't contain any ____________?
Please select the best answer.
A.
Determinants
B.
Repeating groups
C.
Null values in primary key fields
D.
Functional dependencies
2.
A table is in 2NF if the table is in 1NF and what other condition is met?
Please select the best answer.
A.
There are no functional dependencies.
B.
There are no null values in primary key fields.
C.
There are no repeating groups.
D.
There are no attributes that are not functionally dependent on the relation's primary key.
3.
When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?
Please select all the correct answers.
A.
Link the relations by a common field
B.
Remove any functional dependencies from both relations
C.
Assign both relations the same primary key field(s)
D.
Create a primary key(s) for the new relation
