Discussion
Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
- Question
A subquery in an SQL SELECT statement is enclosed in:
Options- A. braces -- {...}.
- B. CAPITAL LETTERS.
- C. parenthesis -- (...) .
- D. brackets -- [...].
- Correct Answer
- parenthesis -- (...) .
- 1. Entities can be associated with one another in which of the following?
Options- A. Entities
- B. Attributes
- C. Identifiers
- D. Relationships Discuss
- 2. The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Options- A. True
- B. False Discuss
- 3. An action assertion is a statement that expresses some aspect of the static structure of the organization.
Options- A. True
- B. False Discuss
- 4. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
- 5. Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).
Options- A. True
- B. False Discuss
- 6. In an object diagram, an object is represented as a rectangle with two compartments.
Options- A. True
- B. False Discuss
- 7. Aggregation is which of the following?
Options- A. Expresses a part-of relationship and is a stronger form of an association relationship.
- B. Expresses a part-of relationship and is a weaker form of an association relationship.
- C. Expresses an is-a relationship and is a stronger form of an association relationship.
- D. Expresses an is-a relationship and is a weaker form of an association relationship. Discuss
- 8. A good identifier is which of the following?
Options- A. One that can change over time
- B. Can be null
- C. One that is unique
- D. Be intelligent Discuss
- 9. 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 Discuss
- 10. 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. Discuss
More questions
Correct Answer: Relationships
Correct Answer: True
Correct Answer: False
Correct Answer: Subtype entity
Correct Answer: False
Correct Answer: True
Correct Answer: Expresses a part-of relationship and is a stronger form of an association relationship.
Correct Answer: One that is unique
Correct Answer: The resulting associative entity has an independent meaning.
Correct Answer: Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.