Discussion
Home ‣ Database ‣ SQL Server 2000 See What Others Are Saying!
- Question
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.
Options- A. True
- B. False
- Correct Answer
- True
- 1. 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
- 2. A subtype entity is a special case of another entity called a supertype entity.
Options- A. True
- B. False Discuss
- 3. A correlated subquery is where the outer query depends on data from the inner query.
Options- A. True
- B. False Discuss
- 4. 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
- 5. 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
- 6. 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
- 7. CASE tools do not include which of the following features?
Options- A. Help to draw data models
- B. Help to generate code
- C. Help to manage people
- D. Create an information repository Discuss
- 8. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Options- A. True
- B. False Discuss
- 9. When an entity instance must be a member of only one subtype, it is which of the following?
Options- A. Disjoint with total specialization
- B. Disjoint with partial specialization
- C. Overlap with total specialization
- D. Overlap with partial specialization Discuss
- 10. A database application can perform which of the following activities?
Options- A. Add records
- B. Read records
- C. Update records
- D. All of the above. Discuss
More questions
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.
Correct Answer: Help to manage people
Correct Answer: True
Correct Answer: Disjoint with total specialization
Correct Answer: All of the above.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.