Discussion
Home ‣ Database ‣ Advanced SQL See What Others Are Saying!
- Question
Which of the following is a correlated subquery?
Options- A. Uses the result of an inner query to determine the processing of an outer query.
- B. Uses the result of an outer query to determine the processing of an inner query.
- C. Uses the result of an inner query to determine the processing of an inner query.
- D. Uses the result of an outer query to determine the processing of an outer query.
- Correct Answer
- Uses the result of an outer query to determine the processing of an inner query.
ExplanationCorrelated subquery references a column in the outer query and executes the subquery once for every row in the outer query while Uncorrelated subquery executes the subquery first and passes the value to the outer query. - 1. Composition does not allow an object to be part of more than one aggregate object.
Options- A. True
- B. False Discuss
- 2. The default extension for SQL*Plus is .sql.
Options- A. True
- B. False Discuss
- 3. Entities of a given type are grouped into a(n):
Options- A. database.
- B. entity class.
- C. attribute.
- D. ERD. Discuss
- 4. A UML diagram includes which of the following?
Options- A. Class name
- B. List of attributes
- C. List of operations
- D. All of the above. Discuss
- 5. What is the overall responsibility of the DBA?
Options- A. Facilitate the development and use of the database
- B. Create and populate tables
- C. Development, operation, and maintenance of the database and its applications
- D. Both the first and third answers above are correct. Discuss
- 6. The ODBC Level 1 API contains which of the following functions?
Options- A. Browse possible connections and data sources only
- B. Connect to data sources with driver-specific information only
- C. Process a scrollable cursor only
- D. Both 1 and 3 above are in the OBDC Level 1 API. Discuss
- 7. SERIALIZABLE is the strictest isolation level.
Options- A. True
- B. False Discuss
- 8. A key:
Options- A. must always be composed of two or more columns.
- B. can only be one column.
- C. identifies a row.
- D. identifies a column. Discuss
- 9. Structured data may include which of the following?
Options- A. Photo image
- B. Video clip
- C. Dates
- D. None of the above. Discuss
- 10. Which of the following is not a restriction for a table to be a relation?
Options- A. The cells of the table must contain a single value.
- B. All of the entries in any column must be of the same kind.
- C. The columns must be ordered.
- D. No two rows in a table may be identical. Discuss
More questions
Correct Answer: True
Correct Answer: True
Correct Answer: entity class.
Correct Answer: All of the above.
Correct Answer: Both the first and third answers above are correct.
Correct Answer: Connect to data sources with driver-specific information only
Correct Answer: True
Correct Answer: identifies a row.
Correct Answer: Dates
Correct Answer: The columns must be ordered.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.