Discussion
Home ‣ Database ‣ Database Redesign See What Others Are Saying!
- Question
The NOT EXISTS keyword will be true if:
Options- A. any row in the subquery meets the condition.
- B. all rows in the subquery fail the condition.
- C. both of these two conditions are met.
- D. neither of these two conditions is met.
- Correct Answer
- all rows in the subquery fail the condition.
- 1. A functional dependency is a relationship between or among:
Options- A. tables.
- B. rows.
- C. relations.
- D. attributes. Discuss
- 2. An extent is which of the following?
Options- A. A keyword that indicates that the subclass inherits from a superclass
- B. A keyword that indicates that the superclass inherits from a subclass
- C. The set of all instances of a class within a database
- D. Only one instance of a class within a database Discuss
- 3. Surrogate keys have much meaning for users.
Options- A. True
- B. False Discuss
- 4. Which one of the following sorts rows in SQL?
Options- A. SORT BY
- B. ALIGN BY
- C. ORDER BY
- D. GROUP BY Discuss
- 5. If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Options- A. All fields are stored in one relation.
- B. All fields are stored in two relations.
- C. All fields are stored in three relations.
- D. All fields are stored in four relations. Discuss
- 6. A relation is in this form if it is in BCNF and has no multivalued dependencies:
Options- A. second normal form.
- B. third normal form.
- C. fourth normal form.
- D. domain/key normal form. Discuss
- 7. SQL statements can be embedded in triggers, stored procedures, and program code.
Options- A. True
- B. False Discuss
- 8. A data warehouse is a database system that is optimized for operational transaction processing.
Options- A. True
- B. False Discuss
- 9. A subtype entity name should be which of the following?
Options- A. A singular noun
- B. Specific to the organization
- C. Concise
- D. All of the above Discuss
- 10. ODBC core SQL grammar contains which of the following?:
Options- A. INSERT, UPDATE, DELETE only
- B. Stored procedures only
- C. Full SELECT (includes subqueries) only
- D. Both 1 and 3 above are contained in the ODBC core SQL. Discuss
More questions
Correct Answer: attributes.
Correct Answer: The set of all instances of a class within a database
Correct Answer: False
Correct Answer: ORDER BY
Correct Answer: All fields are stored in two relations.
Correct Answer: fourth normal form.
Correct Answer: True
Correct Answer: False
Correct Answer: All of the above
Correct Answer: Both 1 and 3 above are contained in the ODBC core SQL.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.