The Oracle Guru Question #2

Are you an Oracle guru? Try your hand at this week's quiz on a component of database table design.

QUESTION OF THE WEEK:

At this level of normalization, each column in a table that is not a determiner of the contents of another column must itself be a function of the other columns in the table. For example, in a table with three columns containing customer ID, product sold and price of the product when sold, the price would be a function of the customer ID (entitled to a discount) and the specific product.

a. 1NF
b. 2NF
c. 3NF
d. DKNF

See ANSWER

This was last published in July 2003

Dig Deeper on Oracle DBA jobs, training and certification

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close