Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. referential integrity constraints.
- C. functional dependencies.
- D. None of the above is correct.
- Correct Answer
- normal forms.
- 1. Concurrency control is important for which of the following reasons?
Options- A. To ensure data integrity when updates occur to the database in a multiuser environment
- B. To ensure data integrity when updates occur to the database in a single-user environment
- C. To ensure data integrity while reading data occurs to the database in a multiuser environment
- D. To ensure data integrity while reading data occurs to the database in a single-user environment Discuss
- 2. User views are included as part of which schema?
Options- A. Internal
- B. Conceptual
- C. External
- D. None of the above. Discuss
- 3. Which of the following is an ordered collection of elements of the same type?
Options- A. Set
- B. Bag
- C. List
- D. Dictionary Discuss
- 4. The fact that the same operation may apply to two or more classes is called what?
Options- A. Inheritance
- B. Polymorphism
- C. Encapsulation
- D. Multiple classification Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. Market basket analysis primarily uses the technique of conditional probabilities.
Options- A. True
- B. False Discuss
- 10. 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
More questions
Correct Answer: To ensure data integrity when updates occur to the database in a multiuser environment
Correct Answer: External
Correct Answer: List
Correct Answer: Polymorphism
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
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.