Discussion
Home ‣ Database ‣ Database Processing for BIS See What Others Are Saying!
- Question
Which of the following is not a reason that operational data are difficult to read?
Options- A. Non-duplicated data
- B. Dirty data
- C. Missing values
- D. Non-integrated data
- Correct Answer
- Non-duplicated data
- 1. A data warehouse administrator is concerned with which of the following?
Options- A. The time to make a decision but not the typical roles of a database administrator
- B. The time to make a decision and the typical roles of a database administrator
- C. The typical roles of a data administrator and redesigning existing applications
- D. The typical roles of a database administrator and redesigning existing applications Discuss
- 2. MySQL is just as powerful as Oracle and is half the price.
Options- A. True
- B. False Discuss
- 3. Client/server security includes which of the following?
Options- A. Physical security
- B. Change control security
- C. Measures taken to secure all systems
- D. All of the above. Discuss
- 4. In ODBC, a data source that is local to a single computer is called a:
Options- A. system data source.
- B. file data source.
- C. user data source.
- D. SQL text file. Discuss
- 5. When mapping a supertype/subtype relationship which of the following is true?
Options- A. The supertype primary key is assigned to each subtype.
- B. The subtype primary key is assigned to each supertype.
- C. There is no link between the supertype/subtype entities.
- D. There is no primary key/foreign key relationship between a supertype/subtype. Discuss
- 6. A subtype entity is a special case of another entity called a supertype entity.
Options- A. True
- B. False Discuss
- 7. A correlated subquery is where the outer query depends on data from the inner query.
Options- A. True
- B. False Discuss
- 8. If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options- A. 1NF.
- B. 2NF.
- C. 3NF.
- D. BCNF. Discuss
- 9. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Options- A. Has ordered recently, orders frequently, and places a large order when she orders.
- B. Hasn't ordered recently, orders infrequently, but places a large order when she orders.
- C. Has ordered recently, orders frequently, but doesn't place a large order when she orders
- D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders. Discuss
- 10. A supertype/subtype hierarchy has which of the following features?
Options- A. Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.
- B. Attributes are assigned at the highest logical level.
- C. Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.
- D. Attributes are assigned at the lowest logical level. Discuss
More questions
Correct Answer: The time to make a decision and the typical roles of a database administrator
Correct Answer: False
Correct Answer: All of the above.
Correct Answer: system data source.
Correct Answer: The supertype primary key is assigned to each subtype.
Correct Answer: True
Correct Answer: False
Correct Answer: BCNF.
Correct Answer: Has ordered recently, orders frequently, but doesn't place a large order when she orders
Correct Answer: Attributes are assigned at the highest logical level.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.