Quiz
Sem título
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (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
Informações
- Descrição
- Quiz sobre Sem título, criado por David Retts em 04-04-2021.
- Autor
- David Retts
- Idioma
- English
- Visualizações
- 0
- Avaliação
- Ainda sem avaliações Avalie este quiz