Discussion
Home ‣ Database ‣ The Internet Database Environment See What Others Are Saying!
- Question
Common Gateway Interface (CGI) is which of the following?
Options- A. An interface that accepts and returns data that may be written in SQL.
- B. An interface that accepts and returns data that may be written in any language that produces an executable file.
- C. A small program that executes within another application and is stored on the server.
- D. A small program that executes within another application and is stored on the client.
- Correct Answer
- An interface that accepts and returns data that may be written in any language that produces an executable file.
- 1. The wildcard in a WHERE clause is useful when?
Options- A. An exact match is necessary in a SELECT statement.
- B. An exact match is not possible in a SELECT statement.
- C. An exact match is necessary in a CREATE statement.
- D. An exact match is not possible in a CREATE statement. Discuss
- 2. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column 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
- 3. Entities can be associated with one another in which of the following?
Options- A. Entities
- B. Attributes
- C. Identifiers
- D. Relationships Discuss
- 4. 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
- 5. An action assertion is a statement that expresses some aspect of the static structure of the organization.
Options- A. True
- B. False Discuss
- 6. 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
- 7. Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).
Options- A. True
- B. False Discuss
- 8. In an object diagram, an object is represented as a rectangle with two compartments.
Options- A. True
- B. False Discuss
- 9. 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
- 10. 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
More questions
Correct Answer: An exact match is not possible in a SELECT statement.
Correct Answer: One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
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
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.