SQL views can be used to hide: columns and rows only. complicated SQL syntax onl

CuriousTab

Home Aptitude

Correct Answer

both of the above can be hidden by an SQL view.

2. Which of the following conditions should exist if you want to convert a relationship to an associative entity?
Options
A. Some of the relationships for the participating entities are "many".
B. The resulting associative entity has an independent meaning.
C. The resulting associative entity has no attributes.
D. All of the above

3. Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
Options
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.

5. Each answer below shows example data from a table. Which answer is an example of the missing values problem?
Options
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.

6. An abstract class is which of the following?
Options
A. A class that has direct instances, but whose descendants may have direct instances.
B. A class that has no direct instances, but whose descendants may have direct instances.
C. A class that has direct instances, but whose descendants may not have direct instances.
D. A class that has no direct instances, but whose descendants may not have direct instances

7. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options
A. MUST COVER
B. MUST NOT
C. Both of the above.
D. None of the above is correct.

Comments