Chapter 1: Overview of Database Concepts
Available Study Resources on Quizplus for this Chatper
108 Verified Questions
108 Flashcards
Source URL: https://quizplus.com/quiz/21418
Sample Questions
Q1) What steps/tasks are required to convert unnormalized data to third normal form (3NF)?
Answer: Any repeating groups are eliminated from the unnormalized data and a primary key is identified to put the data in first normal form. If the primary key is a composite primary key, then any partial dependencies must also be eliminated to convert the data to second normal form. Once the data is in second normal form, any transitive dependencies are eliminated and the data is then in third normal form.
Q2) Which of the following terms represents a collection of fields?
A) field
B) record
C) character
D) file
Answer: B
Q3) _________________________ is a data sublanguage that processes sets of data.
Answer: Structured Query Language
SQL
Q4) A(n) ____________________ is a storage structure that contains data. Answer: database
To view all questions and flashcards with answers, click on the resource link above. Page 3