Quiz
Study Guide Chapter 3 & 4
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (45)
1 A ________ is used to limit the possible values of a foreign key.
- AFunctional Dependency
- BComposite Key
- CReferential Integrity Constraint
- DSurrogate Key
2A classic example of unneeded normalization is when we are dealing with ________.
- AZip Codes
- BAssociation Patterns
- CSales Orders and line Items
- DMultivalued Dependencies
3A combination of one or more columns used to identify particular rows in a relation is a ________.
- ATuple
- BKey
- CRecord
- DField
4 A combination of two or more columns used to identify particular rows in a relation is a ________.
- ASurrogate Key
- BComposite Key
- CForeign Key
- DRecord
5 A determinant that determines all the other columns in a relation is a ________.
- AForeign Key
- BCandidate Key
- CSurrogate Key
- DRecord
6 A form of multivalued dependency is found in ________.
- AThe multivalued, multicolumn problem
- BThe inconsistent values problem
- CThe missing values problem
- DThe general-purpose remarks column problem
7 A key consisting of one or more columns that is a primary key in another relation is a ________.
- AComposite Key
- BCandidate Key
- CForeign Key
- DSurrogate Key
8A missing value is called a(n) ________.
- ADelete Value
- BNull Value
- CEmpty Value
- DMissing Value
9A null value can indicate which of the following conditions?
- AThe value can never change
- BThe value is appropriate but unknown.
- CThe value has been updated.
- DThe value is incorrect.
10 A relation is in fourth normal form if it is in BCNF and it has no ________.
- AMultivalued dependencies
- BPartial dependencies
- CDeletion dependencies
- DTransitive dependencies
11A table that meets the definition of a relation is in ________.
- ASecond Normal Form
- BBoyce-Codd Normal Form
- CThird Normal Form
- DFirst Normal Form
12A table with columns PhoneNumber01, PhoneNumber02, and PhoneNumber03 is likely to have
- AThe multivalue, multicolumn problem
- BThe inconsistent values problem
- CThe missing values problem
- DThe general-purpose remarks column problem
13An advantage of denormalization is ________.
- AFaster copying of data
- BFaster querying
- CFaster design
- DFaster updating
14An artificial column added to a relation to serve as the primary key is a ________.
- AComposite key
- BCandidate key
- CForeign key
- DSurrogate key
15Anomalies caused by functional dependencies can be eliminated by putting tables into ________.
- A1NF
- B2NF
- C3NF
- DBCNF
16 An attribute is also known as a ________.
- ARelation
- BTable
- CRow
- DField
17A relation is also known as a(n) ________.
- ATable
- BRelationship
- CAttribute
- DTuple
18A tuple is also known as a ________.
- ARelation
- BRow
- CTable
- DField
19During the second step of assessing table structure, you are trying to determine ________.
- AMultivalued dependencies
- BMissing Values
- CSubqueries
- DData types
20For a number of reasons, ________ is not often an advantage for a read-only database.
- AUpdating
- BNormalization
- CDenormalization
- DBoth Updating and Normalization are correct
21Having to enter facts about two entities when we want to enter facts about only one is an example of _______.
- ADeletion Anomaly
- BUpdate Anomaly
- CNormalization Anomaly
- DInsertion anomaly
22If a relation is in BCNF, and each multivalued dependency has been moved to a relation of its own,
then the first relation is in ________.- AFourth Normal Form
- BThird Normal Form
- CDomain/Key normal form
- DBoyce-Codd Normal Form
23If a table is designed so that every determinant is a candidate key, then that relation is in ________.
- ABoyce-Codd Normal Form
- BFirst Normal Form
- CSecond Normal Form
- DThird Normal Form
24If the removal of facts about one entity results in the unintentional loss of data about another entity, this is referred to as a(n) ________.
- ANormalization anomaly
- BDeletion anomaly
- CInsertion anomaly
- DUpdate anomaly
25In general, each relation should have ________.
- AOne or more themes
- BOne and only one theme
- COne or two themes
- DExactly two themes
26Read-only databases are used for ________.
- AData entry
- BUser account management
- CUpdating
- DQuerying
27Referential integrity constraints are used to limit the possible values of a ________.
- AComposite key
- BCandidate key
- CForeign key
- DSurrogate key
28Reviewing the work done on a table that was created using existing data from multiple sources, you find that a column named Remarks has been included, and it is populated with inconsistent and verbose verbal data. This is an example of ________.
- AThe inconsistent values problem
- BThe missing values problem
- CThe multivalued, multicolumn problem
- DThe general-purpose remarks column problem
29Suppose that you need to update one value of the column SalesCost in a relation. The way the relation is constructed, this value actually needs to be changed in three different rows. However, you only change the value in two of the rows. You have just created a(n) ________.
- AInsertion anomaly
- BDeletion anomaly
- CUpdate anomaly
- DNormalization anomaly
30The SQL function COUNT ________.
- ACounts the number of tables in a database
- BCounts the number of updates to a database
- CCounts the number of columns in a table
- DCount the number of rows in a table
31The SQL keyword IS NULL can be used to help ________.
- ACount the number of columns in a table
- BCount the number of null values in a column
- CCount the number of rows in a table
- DCount the number of values in a column
32The advantages of normalization include ________.
- AMore complex SQL for multitable subqueries and joins
- BSimpler SQL queries
- CThe elimination of modification anomalies
- DThe elimination of duplicated data
33The defining characteristic of BCNF is that a table is in BCNF if _______.
- AThe primary key is a candidate key
- BAll columns are consistent
- CAll determinants are candidate keys
- DAll rows are unique
34The disadvantages of normalization include ________.
- AThe elimination of modification anomalies
- BThe elimination of duplicated data
- CMore complex SQL for multitable subqueries and joins
- DBoth the elimination of modification anomalies and the elimination of duplicated data are correct
35The first step in assessing table structure includes ________.
- ACounting Rows
- BExamining columns
- CExamining data values
- DBoth counting rows and examining columns are correct
36The only reason(s) for having relations is to ________.
- AStore instances of functional dependencies
- BStore equation components
- CStore equation results
- DBoth store equation components and store equation results are correct
37The presence of one or more foreign keys in a relation prevents ________.
- Athe elimination of modification anomalies
- Bthe elimination of duplicated data
- Cmore complex SQL for multitable subqueries and joins
- DBoth the elimination of modification anomalies and the elimination of duplicated data are
correct
38The problem of misspelled data entries is really the same as ________.
- Athe multivalue, multicolumn problem
- Bthe inconsistent values problem
- Cthe missing values problem
- Dthe general-purpose remarks column problem
39The second step in assessing table structure includes ________.
- ACounting rows
- BExamining Columns
- CExamining data values
- DCounting rows and examining columns
40Unlike the anomalies from functional dependencies, the anomalies from ________ are so serious that they should always be eliminated.
- AAssociation Patterns
- BGeneral purpose remarks columns
- CMultivalued dependencies
- DSales orders and line items
41When a table is created using existing data from multiple sources, you are likely to find that the different sources code data in slightly different ways. This is an example of ________.
- Athe multivalued, multicolumn problem
- Bthe inconsistent values problem
- Cthe missing values problem
- Dthe general-purpose remarks column problem
42When a table is created using existing data from multiple sources, you are likely to find that some data values have never been provided because the values are not known. This is an example of ________.
- Athe multivalued, multicolumn problem
- Bthe inconsistent values problem
- Cthe missing values problem
- Dthe general-purpose remarks column problem
43When designing a database, one of the candidate keys in a relation is selected as the ________.
- APrimary Key
- BForeign Key
- CComposite Key
- DSurrogate Key
44When you are given a set of tables and asked to create a database to store their data, the first step is to ________.
- Acreate one or more new tables
- Bassess the existing tables' structure and content
- Cmove the data into the new database
- Ddesign the database structure
45________ is the process of joining two or more tables and storing the result as a single table.
- AQuerying
- BUpdating
- CNormalization
- DDenormalization
Information
- Description
- 1 ITD 256 Quiz on Study Guide Chapter 3 & 4, created by jereznel on 25/05/2016.
- Author
- jereznel
- Language
- English
- Views
- 7
- Tags
- Rating
- No ratings yet Rate this quiz