Discussion
Home ‣ Database ‣ Data Models into Database Designs See What Others Are Saying!
- Question
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Options- A. the primary key
- B. any alternate key
- C. a surrogate key
- D. a foreign key
- Correct Answer
- the primary key
- 1. A regular subquery can be processed:
Options- A. from the top down.
- B. from the bottom up.
- C. by nesting.
- D. None of the above is correct. Discuss
- 2. Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities Discuss
- 3. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
- 4. The SQL statement that queries or reads data from a table is ________ .
Options- A. SELECT
- B. READ
- C. QUERY
- D. None of the above is correct. Discuss
- 5. A foreign key is which of the following?
Options- A. Any attribute
- B. The same thing as a primary key
- C. An attribute that serves as the primary key of another relation
- D. An attribute that serves no purpose Discuss
- 6. Most operational databases can be used for many BI applications.
Options- A. True
- B. False Discuss
- 7. Given the functional dependency R ? (S,T) , then it is also true that R ? S.
Options- A. True
- B. False Discuss
- 8. Which is not true of a correlated subquery?
Options- A. EXISTS/NOT EXISTS is a form of a correlated subquery.
- B. The processing of the SELECT statements is nested.
- C. They can be used to verify functional dependencies.
- D. They are very similar to a regular subquery. Discuss
- 9. One popular classification technique in Business Intelligence (BI) reporting is ________ .
Options- A. cluster analysis only
- B. regression analysis only
- C. RFM analysis only
- D. both cluster analysis and regression analysis Discuss
- 10. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
Options- A. True
- B. False Discuss
More questions
Correct Answer: from the bottom up.
Correct Answer: All of the above use ID dependent entities
Correct Answer: Increased network traffic
Correct Answer: SELECT
Correct Answer: An attribute that serves as the primary key of another relation
Correct Answer: False
Correct Answer: True
Correct Answer: They are very similar to a regular subquery.
Correct Answer: RFM analysis only
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.