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 […]
Category Archives: sql Certificate
SQL – Creating Other Schema Objects Questions 1. Which database object among the following provides a layer of abstraction between the users and the data? Table Rows Views Synonyms Answer: C, D. Views and Synonyms do not store data themselves. A view is a temporary or virtual table used to retrieve data stored in underlying […]
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 […]