Discussion
Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
- Question
Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
Options- A. True
- B. False
- Correct Answer
- False
- 1. The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
Options- A. Overlapping rule
- B. Disjoint rule
- C. Total specialization rule
- D. Partial specialization rule Discuss
- 2. ODL supports which of the following types of association relationships?
Options- A. Unary
- B. Unary and Binary
- C. Unary and Binary and Ternary
- D. Unary and Binary and Ternary and higher Discuss
- 3. You may specify an object identifier with only one unique tag name.
Options- A. True
- B. False Discuss
- 4. Which of the following is true concerning open-source DBMS?
Options- A. Is free or nearly free database software whose source code is publicly available
- B. Is free or nearly free database software whose source code is not publicly available
- C. Is not competitive against PC-oriented packages and is fully SQL compliant
- D. Is competitive against PC-oriented packages and is not fully SQL compliant Discuss
- 5. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Options- A. GROUP BY.
- B. WHERE.
- C. ORDER BY.
- D. FROM. Discuss
- 6. A server cannot serve on which of the following levels?
Options- A. Client Layer
- B. Business Layer
- C. Database Layer
- D. All of the above. 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. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options- A. Nonrepeatable read
- B. Phantom read
- C. Dirty read
- D. Consistent read Discuss
- 9. The wildcard in a WHERE clause is useful when?
Options- A. An exact match is necessary in a SELECT statement.
- B. An exact match is not possible in a SELECT statement.
- C. An exact match is necessary in a CREATE statement.
- D. An exact match is not possible in a CREATE statement. Discuss
- 10. Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Discuss
More questions
Correct Answer: Partial specialization rule
Correct Answer: Unary and Binary
Correct Answer: False
Correct Answer: Is free or nearly free database software whose source code is publicly available
Correct Answer: ORDER BY.
Correct Answer: Client Layer
Correct Answer: Overlap with total specialization
Correct Answer: Dirty read
Correct Answer: An exact match is not possible in a SELECT statement.
Correct Answer: One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.