Discussion
Home ‣ Database ‣ Database Redesign See What Others Are Saying!
- Question
Database redesign is not terribly difficult if the:
Options- A. database is structured.
- B. database is well-designed.
- C. database has no data.
- D. database is relatively small.
- Correct Answer
- database has no data.
- 1. The benefits of object-oriented modeling are which of the following?
Options- A. The ability to tackle more challenging problems
- B. Reusability of analysis, design, and programming results
- C. Improved communication between users, analysts, etc.
- D. All of the above. Discuss
- 2. A heterogeneous distributed database is which of the following?
Options- A. The same DBMS is used at each location and data are not distributed across all nodes.
- B. The same DBMS is used at each location and data are distributed across all nodes.
- C. A different DBMS is used at each location and data are not distributed across all nodes.
- D. A different DBMS is used at each location and data are distributed across all nodes. Discuss
- 3. Which SQL-92 standard SQL command can be used to change a table name?
Options- A. RENAME TABLE
- B. CHANGE TABLE
- C. ALTER TABLE
- D. None of the above is correct. Discuss
- 4. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
Options- A. True
- B. False Discuss
- 5. Market basket analysis primarily uses the technique of conditional probabilities.
Options- A. True
- B. False Discuss
- 6. A stored procedure is a program that performs some common action on database data and is stored in the database.
Options- A. True
- B. False Discuss
- 7. If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
Options- A. True
- B. False Discuss
- 8. Which of the following columns is(are) are required in a table?
Options- A. A foreign key
- B. An alternate key
- C. A primary key
- D. A surrogate key. Discuss
- 9. Packaged data models are meant to be exactly right straight out of the box.
Options- A. True
- B. False Discuss
- 10. 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 Discuss
More questions
Correct Answer: All of the above.
Correct Answer: A different DBMS is used at each location and data are distributed across all nodes.
Correct Answer: None of the above is correct.
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: A primary key
Correct Answer: False
Correct Answer: the primary key
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.