CET_TARDE - MTA Database - STANDARDS

Pregunta 1 de 5

1

First normal form requires that a database excludes:

Selecciona una de las siguientes respuestas posibles:

Foreign keys
Composite keys
Duplicate rows
Repeating groups

Explicación

Pregunta 2 de 5

1

Denormalization is performed in order to:

Selecciona una de las siguientes respuestas posibles:

Reduce redundancy.
Eliminate repeating groups.
Create smaller tables.
Improve query performance.

Explicación

Pregunta 3 de 5

1

You have a table that contains the following data image.

This process is referred to as:

Selecciona una de las siguientes respuestas posibles:

defragmentation
normalization
fragmentation
denormalization

Explicación

Pregunta 4 de 5

1

This question requires that you evaluate the underlined text to determine if it is correct. You combine data from three tables into one table. The new table includes redundancy to optimize read performance. The data in the new table has been denormalized.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

Selecciona una de las siguientes respuestas posibles:

No change is needed
Normalized
Truncated
Indexed

Explicación

Pregunta 5 de 5

1

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data image:

You need to normalize the data to third normal form. How many tables should you create?

Selecciona una de las siguientes respuestas posibles:

1
2
3
4

	Creado por Hawerth Castro hace alrededor de 9 años

Database Fundamentals Quizzes preparing to certification

CET_TARDE - MTA Database - STANDARDS

Pregunta 1 de 5

First normal form requires that a database excludes:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 5

Denormalization is performed in order to:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 5

You have a table that contains the following data image. This process is referred to as:

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 5

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 5

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data image: You need to normalize the data to third normal form. How many tables should you create?

Selecciona una de las siguientes respuestas posibles:

Explicación

You have a table that contains the following data image.

This process is referred to as:

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data image:

You need to normalize the data to third normal form. How many tables should you create?