Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

A Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C Three rows have the values Brown, NULL, and Blue in the same column.
D One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Correct Answer: Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

Bissoy MCQ
#Database #Database Design Using Normalization

Related Questions

Each answer below shows example data from a table. Which answer is an example of the missing values problem?
A Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C Three rows have the values Brown, NULL, and Blue in the same column.
D One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
A T
B U
C V
D Z
One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
A True
B False
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
A Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row
B Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column
C Three rows have the values Brown, NULL, and Blue in the same column
D One row has the value “He is interested in a Silver Porsche from the years 1978-1988” in a column
Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
A Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
B Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
C Three rows have the values Brown, NULL, and Blue in the same column.
D One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Ten new television shows appeared during the month of September. Five of the shows were sitcoms, three were hour-long dramas, and two were news-magazine shows. By January, only seven of these new shows were still on the air. Five of the shows that remained were sitcoms.
A Only one of the news-magazine shows remained on the air.
B Only one of the hour-long dramas remained on the air.
C At least one of the shows that was cancelled was an hour-long drama.
D Television viewers prefer sitcoms over hour-long dramas.
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. Which of the following is an acceptable sequence of negotiators around the table ?
A M,S,R,T,P,O
B M,S,T,P,R,O
C T,O,P,S,M,R
D T,R,M,P,S,O
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits directly across the table from O, who must sit on the other side of P?
A M and O
B M and S
C O and R
D O and S
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If M sits next to P which of the following is a complete and accurate list of those who can sit next to P on P's other side ?
A O
B O,S
C O,S,R
D R,S,T
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits next to M and S sits next to R, which of the other negotiators must sit next to s ?
A M
B O
C P
D R

Next steps