Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
For some relations, changing the data can have undesirable consequences called:
Options- A. referential integrity constraints.
- B. modification anomalies.
- C. normal forms.
- D. transitive dependencies.
- Correct Answer
- modification anomalies.
- 1. The benefits of a standard relational language include which of the following?
Options- A. Reduced training costs
- B. Increased dependence on a single vendor
- C. Applications are not needed.
- D. All of the above. Discuss
- 2. In ODL, you specify an operation using parentheses after its name.
Options- A. True
- B. False Discuss
- 3. The JVM (Java virtual machine) interprets Java bytecode at run time.
Options- A. True
- B. False Discuss
- 4. A rule of thumb for choosing indexes for a relational database includes which of the following?
Options- A. Indexes are more useful on smaller tables.
- B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
- C. Do not specify a unique index for the primary key of each table.
- D. Be careful indexing attributes that have null values. Discuss
- 5. Changing cardinalities in a database is:
Options- A. a common database design task.
- B. a rare database design task, but does occur.
- C. a database design task that never occurs.
- D. is impossible to do, so a new database must be constructed and the data moved into it. Discuss
- 6. ________ is an object-oriented interface that encapsulates data-server functionality.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
- 7. The following are components of a database except ________ .
Options- A. user data
- B. metadata
- C. reports
- D. indexes Discuss
- 8. Which of the following is a technique for hiding the internal implementation details of an object?
Options- A. Encapsulation
- B. Polymorphism
- C. Inheritance
- D. All of the above. Discuss
- 9. The three-schema components include all, but:
Options- A. internal schema.
- B. conceptual schema.
- C. programming schema.
- D. external schema. Discuss
- 10. Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.
Options- A. True
- B. False Discuss
More questions
Correct Answer: Reduced training costs
Correct Answer: True
Correct Answer: True
Correct Answer: Be careful indexing attributes that have null values.
Correct Answer: a common database design task.
Correct Answer: OLE DB
Correct Answer: reports
Correct Answer: Encapsulation
Correct Answer: programming schema.
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.