Discussion
Home ‣ Database ‣ ODBC, OLE DB, ADO, and ASP See What Others Are Saying!
- Question
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
Options- A. ODBC
- B. ASP
- C. JPCD
- D. ADO
- Correct Answer
- ADO
- 1. 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
- 2. A functional dependency is a relationship between or among attributes.
Options- A. True
- B. False Discuss
- 3. 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
- 4. 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
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. A data warehouse is which of the following?
Options- A. Can be updated by end users.
- B. Contains numerous naming conventions and formats.
- C. Organized around important subject areas.
- D. Contains only current data. Discuss
More questions
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.
Correct Answer: Organized around important subject areas.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.