Discussion
Home ‣ Technical Questions ‣ Database Comments
- Question
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.
- Correct Answer
- Acts like a WHERE clause but is used for groups rather than rows.
- 1. 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
- 2. 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
- 3. 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 Discuss
- 4. Parenthesis is never required in Postfix or Prefix expressions
Options- A. TRUE
- B. FALSE Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
Options- A. first step.
- B. second step.
- C. third step.
- D. fourth step. Discuss
- 9. Legacy data is which of the following?
Options- A. Data contained in a newly-installed system
- B. Data rejected during the installation of a new system
- C. Data contained in a file system
- D. Data contained by a system used prior to the installation of a new system Discuss
- 10. The command to eliminate a table from a database is
Options- A. REMOVE TABLE CUSTOMER;
- B. UPDATE TABLE CUSTOMER;
- C. DELETE TABLE CUSTOMER;
- D. DROP TABLE CUSTOMER; Discuss
Database problems
Search Results
Correct Answer: Overlap with total specialization
Correct Answer: global elements.
Correct Answer: Supertype entity
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: Both IN and NOT IN.
Correct Answer: BCNF
Correct Answer: third step.
Correct Answer: Data contained by a system used prior to the installation of a new system
Correct Answer: DROP TABLE CUSTOMER;
Explanation:
The SQL DROP TABLE statement is used to remove a table definition and all data, indexes,...
Comments
There are no comments.More in Technical Questions:
Programming
Copyright ©CuriousTab. All rights reserved.