Discussion
Home ‣ Database ‣ Data Warehousing See What Others Are Saying!
- Question
Data scrubbing is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse
- Correct Answer
- A process to upgrade the quality of data before it is moved into a data warehouse
- 1. The benefits of a standard relational language include which of the following?
Options- A. Reduced training costs
- B. Increased dependence on a single vendor
- C. Applications are not needed.
- D. All of the above. Discuss
- 2. In ODL, you specify an operation using parentheses after its name.
Options- A. True
- B. False Discuss
- 3. The JVM (Java virtual machine) interprets Java bytecode at run time.
Options- A. True
- B. False Discuss
- 4. A rule of thumb for choosing indexes for a relational database includes which of the following?
Options- A. Indexes are more useful on smaller tables.
- B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
- C. Do not specify a unique index for the primary key of each table.
- D. Be careful indexing attributes that have null values. Discuss
- 5. Changing cardinalities in a database is:
Options- A. a common database design task.
- B. a rare database design task, but does occur.
- C. a database design task that never occurs.
- D. is impossible to do, so a new database must be constructed and the data moved into it. Discuss
- 6. ________ is an object-oriented interface that encapsulates data-server functionality.
Options- A. ODBC
- B. OLE DB
- C. JPCD
- D. ADO Discuss
- 7. The following are components of a database except ________ .
Options- A. user data
- B. metadata
- C. reports
- D. indexes Discuss
- 8. Which of the following is a technique for hiding the internal implementation details of an object?
Options- A. Encapsulation
- B. Polymorphism
- C. Inheritance
- D. All of the above. Discuss
- 9. The three-schema components include all, but:
Options- A. internal schema.
- B. conceptual schema.
- C. programming schema.
- D. external schema. Discuss
- 10. Routers are used to transmit message packets and forward them to the correct destination over the most efficient pathway available.
Options- A. True
- B. False Discuss
More questions
Correct Answer: Reduced training costs
Correct Answer: True
Correct Answer: True
Correct Answer: Be careful indexing attributes that have null values.
Correct Answer: a common database design task.
Correct Answer: OLE DB
Correct Answer: reports
Correct Answer: Encapsulation
Correct Answer: programming schema.
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.