Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity
- Correct Answer
- Supertype entity
- 1. Parenthesis is never required in Postfix or Prefix expressions
Options- A. TRUE
- B. FALSE Discuss
- 2. It is necessary to sort a file before searching a particular item
Options- A. True
- B. False
- C. May or may not be true
- D. None of the above Discuss
- 3. A transitive dependency is which of the following?
Options- A. A functional dependency between two or more key attributes.
- B. A functional dependency between two or more nonkey attributes.
- C. A relation that is in first normal form.
- D. A relation that is in second normal form. Discuss
- 4. A shared database should:
Options- A. be accurate and available.
- B. provide for backup and recovery.
- C. be secure.
- D. All of the above. Discuss
- 5. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 6. To eliminate definition duplication, XML Schemas define:
Options- A. an intersection table.
- B. global elements.
- C. a normalized definition table.
- D. None of the above is correct. Discuss
- 7. When an entity instance may be a member of multiple subtypes or it does not have to be a member of a 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
- 8. The HAVING clause does which of the following?
Options- A. Acts like a WHERE clause but is used for groups rather than rows.
- B. Acts like a WHERE clause but is used for rows rather than columns.
- C. Acts like a WHERE clause but is used for columns rather than groups.
- D. Acts EXACTLY like a WHERE clause. Discuss
- 9. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Options- A. LIKE only.
- B. IN only.
- C. NOT IN only.
- D. Both IN and NOT IN. Discuss
- 10. 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
Database problems
Search Results
Correct Answer: TRUE
Explanation:
Parenthesis is not required because the order of the operators in the postfix /prefix expressions determines the actual order of operations in evaluating the expression
Correct Answer: May or may not be true
Explanation:
If less work is involved in searching a element than to sort and then extract, then we don?t go for sort
If frequent use of the file is required for the purpose of retrieving specific element, it is more efficient to sort the file.
Thus it depends on situation
Correct Answer: A functional dependency between two or more nonkey attributes.
Correct Answer: All of the above.
Correct Answer: Six
Correct Answer: global elements.
Correct Answer: Overlap with total specialization
Correct Answer: Acts like a WHERE clause but is used for groups rather than rows.
Correct Answer: Both IN and NOT IN.
Correct Answer: BCNF
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.