Discussion
Home ‣ Database ‣ The Client-Server Database See What Others Are Saying!
- Question
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options- A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
- B. Requires certain criteria to be met in order to establish an ODBC connection.
- C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
- D. All of the above.
- Correct Answer
- All of the above.
- 1. A regular subquery can be processed:
Options- A. from the top down.
- B. from the bottom up.
- C. by nesting.
- D. None of the above is correct. Discuss
- 2. Which of the following situation requires the use of ID-dependent entities?
Options- A. Association relationships only
- B. Multivalued attributes only
- C. Archetype/instance relationships only
- D. All of the above use ID dependent entities Discuss
- 3. What is not an advantage of stored procedures?
Options- A. Greater security
- B. SQL can be optimized
- C. Code sharing
- D. Increased network traffic Discuss
- 4. The SQL statement that queries or reads data from a table is ________ .
Options- A. SELECT
- B. READ
- C. QUERY
- D. None of the above is correct. Discuss
- 5. A foreign key is which of the following?
Options- A. Any attribute
- B. The same thing as a primary key
- C. An attribute that serves as the primary key of another relation
- D. An attribute that serves no purpose Discuss
- 6. Most operational databases can be used for many BI applications.
Options- A. True
- B. False Discuss
- 7. Given the functional dependency R ? (S,T) , then it is also true that R ? S.
Options- A. True
- B. False Discuss
- 8. Which is not true of a correlated subquery?
Options- A. EXISTS/NOT EXISTS is a form of a correlated subquery.
- B. The processing of the SELECT statements is nested.
- C. They can be used to verify functional dependencies.
- D. They are very similar to a regular subquery. Discuss
- 9. One popular classification technique in Business Intelligence (BI) reporting is ________ .
Options- A. cluster analysis only
- B. regression analysis only
- C. RFM analysis only
- D. both cluster analysis and regression analysis Discuss
- 10. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.
Options- A. True
- B. False Discuss
More questions
Correct Answer: from the bottom up.
Correct Answer: All of the above use ID dependent entities
Correct Answer: Increased network traffic
Correct Answer: SELECT
Correct Answer: An attribute that serves as the primary key of another relation
Correct Answer: False
Correct Answer: True
Correct Answer: They are very similar to a regular subquery.
Correct Answer: RFM analysis only
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.