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. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
Options- A. user data.
- B. metadata
- C. A report
- D. indexes Discuss
- 2. For what purposes are views used?
Options- A. To hide columns only
- B. To hide rows only
- C. To hide complicated SQL statements only
- D. All of the above are uses for SQL views. Discuss
- 3. What MySQL property is used to create a surrogate key in MySQL?
Options- A. UNIQUE
- B. SEQUENCE
- C. AUTO_INCREMENT
- D. None of the above -- Surrogate keys are not implemented in MySQL. Discuss
- 4. 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
- 5. User views are included as part of which schema?
Options- A. Internal
- B. Conceptual
- C. External
- D. None of the above. Discuss
- 6. Which of the following is an ordered collection of elements of the same type?
Options- A. Set
- B. Bag
- C. List
- D. Dictionary Discuss
- 7. 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
- 8. 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
- 9. 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
- 10. 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
More questions
Correct Answer: metadata
Correct Answer: All of the above are uses for SQL views.
Correct Answer: AUTO_INCREMENT
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.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.