Test
Sin título
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 (6)
1In general, denormalization produces
- Amore join
- Ba slower system response
- Cless data redundancy
- Dfaster performance.
2Some normalization forms are
- A1NF
- B2NF
- C3NF
- Dall of the above
- Enone of the above
3A table that displays data redundancies yields the following anomalies:
- Aupdate anomalies
- Binsertion anomalies
- Cdeletion anomalies
- Dall of the above
- Enone of the above
4The term first normal form (1NF) describes the tabular format in which:
- Aall the key attributes are defined.
- Bthere are no repeating groups in the table. Row/column intersection can contain one and only one value, not a set of values.
- Call attributes are dependent on the primary key
- Dall of the above
- Enone of the above
5A table is in the Fourth Normal Form (4NF) if
- AAll attributes must be dependent on the primary key, and must be dependent on each other.
- BAll attributes must be dependent on the primary key, but must be independent of each other.
- CNo row can contain two or more multivalued facts about an entity
- DA and C
- EB and C
6The conflicts between design efficiency, information requirements, and processing speed are often resolved through
- Aconversion from 1NF to 2NF
- Bconversion from 2NF to 3NF
- Ccompromises that include denormalization
- Dconversion from 3NF to 4NF
Información
- Descripción
- Test sobre Sin título, creado por David Retts el 04/04/2021.
- Autor
- David Retts
- Idioma
- English
- Visitas
- 0
- Valoración
- Aún sin valoraciones Valora este test