9638164
Beschreibung
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
|
Erstellt von Hawerth Castro
vor mehr als 7 Jahre
|
|
Frage 1
Frage
First normal form requires that a database excludes:
Antworten
-
Foreign keys
-
Composite keys
-
Duplicate rows
-
Repeating groups
Frage 2
Frage
Denormalization is performed in order to:
Antworten
-
Reduce redundancy.
-
Eliminate repeating groups.
-
Create smaller tables.
-
Improve query performance.
Frage 3
Frage
You have a table that contains the following data image.
This process is referred to as:
Image:
1 (binary/octet-stream)
Antworten
-
defragmentation
-
normalization
-
fragmentation
-
denormalization
Frage 4
Frage
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.
Antworten
-
No change is needed
-
Normalized
-
Truncated
-
Indexed
Frage 5
Frage
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?
Image:
2 (binary/octet-stream)
Antworten
-
1
-
2
-
3
-
4
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.