Quiz
Quiz 3 - Chapter 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 (20)
11) ________ in a well-structured relational database.
- AA) Every table must be related to all other tables
- BC) Every table must be related to at least one other table
22) A row in a table that contains data about a specific item in a database table is call
- AA) a data model.
- BC) a tuple.
33) An attribute in a table that serves as a unique identifier in another table and is used to link the
two tables is a- AA) foreign key.
- BB) primary key
44) The problem of changes being incorrectly recorded in a database is known as
- AA) an update anomaly.
- BB) an insert anomaly
55) The ________ occurs when more than one occurrence of a specific data item in a database
exists.- AD) update anomalyem
- BC) delete anomaly
66) Inability to add new data to a database without violating the basic integrity of the database is
referred to as the- AA) update anomaly.
- BB) insert anomalyord.
77) A relational database in which vendor data is not maintained independently of purchase order
data will most likely result in- AA) an update anomaly.
- BB) an insert anomaly.
88) The problem of losing desired information from a database when an unwanted record is
purged from the database is referred to as the ________ anomaly.- AB) erase
- BC) delete
99) Identify one potential outcome of the delete anomaly.
- AA) inconsistent data
- BC) unintentional loss of datanal
1010) Identify one potential outcome of the insert anomaly.
- AB) inability to add new data
- BA) inconsistent data
1111) Identify one potential outcome of the update anomaly.
- AB) inability to add new data
- BA) inconsistent data
1212) The update anomaly in non-normalized database tables
- AB) restricts addition of new fields or attributesmaly.
- BA) occurs because of data redundancy.
1323) How do users retrieve data stored in a database?
- AC) by performing a search
- BB) by executing a query
1424) In a well-structured relational database,
- AA) foreign keys cannot be null.
- BC) every column in a row must be single valued
1525) Which of the following is false regarding a well-structured relational database?
- AA) A foreign key cannot be null.
- BB) A primary key cannot be null.st be single valued.y.a.
1627) In a relational database, requiring that every record in a table have a unique identifier is
called the- AA) entity integrity rule.
- BB) referential integrity rule
1728) The database requirement that foreign keys must be null or have a value corresponding to the
value of a primary key in another table is formally called the- AA) entity integrity rule.
- BB) referential integrity rule.
1832) In the database design approach known as normalization, the first assumption made about
data is- AB) the delete anomaly will not apply since all customer records will be maintained indefinitely.
- BC) everything is initially stored in one large table.
1933) The database design method in which a designer uses knowledge about business processes to
create a diagram of the elements to be included in the database is called- AC) geometric data modeling.
- BD) semantic data modeling.ule.
2035) A fully normalized database is called
- AC) third normal form (3NF).
- BB) second normal form (2NF).
Information
- Description
- AIS - 166 Quiz on Quiz 3 - Chapter 4, created by Mahmoud Hemood on 22/10/2019.
- Author
- Mahmoud Hemood
- Language
- English
- Views
- 0
- History
- Created on 22 Oct 2019 · updated on 22 Oct 2019
- Tags
- Rating
- No ratings yet Rate this quiz