SQL – Using DDL Statements Questions 1.What is the full form of DDL in Oracle DB? Data Deleting Language Data Definition Language Data Delegating Language Dummy Data Language Answer: B. DDL is one of the categories of SQL which stands for Data Definition Language. Other SQL types are DML, DCL, and TCL. 2.DDL statements are […]
Category Archives: sql Certificate
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 […]
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 […]