SQL – Subqueries to Solve Queries Questions 1. Which of the following are the types of sub-queries? Ordered sub-queries Grouped sub-queries Single row sub-queries None of the above Answer: C. A subquery is a complete query nested in the SELECT,FROM, HAVING, or WHERE clause of another query.The subquery must be enclosed in parentheses and have […]
Category Archives: sql Certificate
SQL – Using the Set Operators Questions 1.Which SET operator does the following figure indicate? UNION UNION ALL INTERSECT MINUS Answer: A. Set operators are used to combine the results of two (or more) SELECT statements.Valid set operators in Oracle 11g are UNION, UNION ALL, INTERSECT, and MINUS. When used with two SELECT statements, the […]
SQL Certificate – Useful Resources The following resources contain additional information on SQL Certificate. Please use them to get more in-depth knowledge on this topic. Useful Links on SQL Certificate − Database Language SQL (Proposed revised text of DIS 9075) July 1992 (Second Informal Review Draft). − DB2 resource for SQL users. − Oracle SQL […]