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. OnLine Analytical Processing (OLAP) is a BI reporting system.
Options- A. True
- B. False Discuss
- 2. A transaction in which either all of the database actions occur or none of them do is called:
Options- A. atomic.
- B. consistent.
- C. isolated.
- D. durable. Discuss
- 3. How many JDBC driver types does Sun define?
Options- A. One
- B. Two
- C. Three
- D. Four Discuss
- 4. The SQL statement used to create a view is CREATE VIEW.
Options- A. True
- B. False Discuss
- 5. For every relationship, there are six possible sets of minimum cardinalities.
Options- A. True
- B. False Discuss
- 6. Using ODL, you can define which of the following?
Options- A. Attribute
- B. Structure
- C. Operation
- D. All of the above. Discuss
- 7. The most important reason for data architecture is reliability.
Options- A. True
- B. False Discuss
- 8. A file data source is one that is local to a single computer.
Options- A. True
- B. False Discuss
- 9. The relational model consists of:
Options- A. data in the form of tables.
- B. data redundancy.
- C. operations using non-SQL languages.
- D. unorganized data. Discuss
- 10. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
Options- A. True
- B. False Discuss
More questions
Correct Answer: True
Correct Answer: atomic.
Correct Answer: Four
Correct Answer: True
Correct Answer: False
Correct Answer: All of the above.
Correct Answer: False
Correct Answer: False
Correct Answer: data in the form of tables.
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.