Test
Quiz 3 - Chapter 4
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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).
Información
- Descripción
- AIS - 166 Test sobre Quiz 3 - Chapter 4, creado por Mahmoud Hemood el 22/10/2019.
- Autor
- Mahmoud Hemood
- Idioma
- English
- Visitas
- 0
- Historial
- Creado el 22 oct 2019 · actualizado el 22 oct 2019
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test