Discussion
Home ‣ Database ‣ Database Redesign See What Others Are Saying!
- Question
What SQL command can be used to delete columns from a table?
Options- A. MODIFY TABLE TableName DROP COLUMN ColumnName
- B. MODIFY TABLE TableName DROP ColumnName
- C. ALTER TABLE TableName DROP COLUMN ColumnName
- D. ALTER TABLE TableName DROP ColumnName
- Correct Answer
- ALTER TABLE TableName DROP COLUMN ColumnName
- 1. An action assertion must include which of the following?
Options- A. Anchor object
- B. Action
- C. Corresponding object
- D. All of the above. Discuss
- 2. Use of a supertype/subtype relationship is necessary when which of the following exists?
Options- A. An instance of a subtype participates in a relationship that is unique to that subtype.
- B. An instance of a subtype participates in a relationship that is the same as the other subtypes.
- C. Attributes apply to all of the instances of an entity type.
- D. No attributes apply to any of the instances of an entity type. Discuss
- 3. What SQL command can be used to add columns to a table?
Options- A. MODIFY TABLE TableName ADD COLUMN ColumnName
- B. MODIFY TABLE TableName ADD ColumnName
- C. ALTER TABLE TableName ADD COLUMN ColumnName
- D. ALTER TABLE TableName ADD ColumnName Discuss
- 4. A homogenous 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
- 5. 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. Discuss
- 6. An on-line commercial site such as Amazon.com is an example of a(n) ________ .
Options- A. single-user database application
- B. multiuser database application
- C. e-commerce database application
- D. data mining database application Discuss
- 7. Location transparency allows for which of the following?
Options- A. Users to treat the data as if it is at one location
- B. Programmers to treat the data as if it is at one location
- C. Managers to treat the data as if it is at one location
- D. All of the above. Discuss
- 8. Which of the following is not one of the three ways to classify an action assertion?
Options- A. Condition
- B. Integrity Control
- C. Authorization
- D. Enabler Discuss
- 9. Every key used to join the fact table with a dimensional table should be a surrogate key.
Options- A. True
- B. False Discuss
- 10. Which of the following is true concerning a global transaction?
Options- A. The required data are at one local site and the distributed DBMS routes requests as necessary.
- B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
- C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
- D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS. Discuss
More questions
Correct Answer: All of the above.
Correct Answer: An instance of a subtype participates in a relationship that is unique to that subtype.
Correct Answer: ALTER TABLE TableName ADD ColumnName
Correct Answer: The same DBMS is used at each location and data are distributed across all nodes.
Correct Answer: modification anomalies.
Correct Answer: e-commerce database application
Correct Answer: All of the above.
Correct Answer: Enabler
Correct Answer: True
Correct Answer: The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.