Discussion
Home ‣ Database ‣ The Database Environment See What Others Are Saying!
- Question
An enterprise data model is:
Options- A. a graphical model that shows the high-level entities for an organization.
- B. a graphical model that shows all entities for an organization.
- C. a non-graphical model that shows the high-level entities for an organization.
- D. a non-graphical model that shows the all entities for an organization.
- Correct Answer
- a graphical model that shows the high-level entities for an organization.
- 1. Typically, there should be at least two different copies of the database schema used in the redesign process.
Options- A. True
- B. False Discuss
- 2. A primary key is which of the following?
Options- A. Any attribute
- B. An attribute that uniquely identifies each row
- C. An attribute that uniquely identifies each column
- D. A derived attribute Discuss
- 3. A functional dependency is a relationship between or among attributes.
Options- A. True
- B. False Discuss
- 4. Selecting a data type involves which of the following?
Options- A. Maximize storage space
- B. Represent most values
- C. Improve data integrity
- D. All of the above. Discuss
- 5. Which of the following are integrity controls that a DBMS may support?
Options- A. Assume a default value in a field unless a user enters a value for that field.
- B. Limit the set of permissible values that a field may assume.
- C. Limit the use of null values in some fields.
- D. All of the above. Discuss
- 6. The extract process is which of the following?
Options- A. Capturing all of the data contained in various operational systems
- B. Capturing a subset of the data contained in various operational systems
- C. Capturing all of the data contained in various decision support systems
- D. Capturing a subset of the data contained in various decision support systems Discuss
- 7. The SQL keyword BETWEEN is used:
Options- A. for ranges.
- B. to limit the columns displayed.
- C. as a wildcard.
- D. None of the above is correct. Discuss
- 8. Which of the following statements is true concerning JDBC?
Options- A. It is language independent.
- B. It is similar in concept to ODBC.
- C. It is useful for all object-oriented languages.
- D. It consists of three main layers. Discuss
- 9. The three different application logic components are which of the following?
Options- A. Presentation, Client, and Storage
- B. Presentation, Client, and Processing
- C. Presentation, Processing, and Storage
- D. Presentation, Processing, and Network Discuss
- 10. An application program interface (API) is which of the following?
Options- A. The same thing as ODBC.
- B. Middleware that does not provide access to a database.
- C. Middleware that provides access to a database.
- D. The same thing as JDBC. Discuss
More questions
Correct Answer: False
Correct Answer: An attribute that uniquely identifies each row
Correct Answer: True
Correct Answer: Improve data integrity
Correct Answer: All of the above.
Correct Answer: Capturing a subset of the data contained in various operational systems
Correct Answer: for ranges.
Correct Answer: It is similar in concept to ODBC.
Correct Answer: Presentation, Processing, and Storage
Correct Answer: Middleware that provides access to a database.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.