Question: A correlated subquery is where the outer query depends on data from the inner query. [A]. True [B]. False Answer: Option B Explanation: No answer description available for this question.

Question: A function returns one value and has only output parameters. [A]. True [B]. False Answer: Option B Explanation: No answer description available for this question.

Question: Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table. [A]. True [B]. False Answer: Option B Explanation: No answer description available for this question.

Question: A CASE SQL statement is which of the following? [A]. A way to establish an IF-THEN-ELSE in SQL. [B]. A way to establish a loop in SQL. [C]. A way to establish a data definition in SQL. [D]. All…

Question: A UNION query is which of the following? [A]. Combines the output from no more than two queries and must include the same number of columns. [B]. Combines the output from no more than two queries and does not…

Question: Which of the following statements is true concerning subqueries? [A]. Involves the use of an inner and outer query. [B]. Cannot return the same result as a query that is not a subquery. [C]. Does not start with the…

Question: Embedded SQL is which of the following? [A]. Hard-coded SQL statements in a program language such as Java. [B]. The process of making an application capable of generating specific SQL code on the fly. [C]. Hard-coded SQL statements in…

Question: Which of the following statements is true concerning routines and triggers? [A]. Both consist of procedural code. [B]. Both have to be called to operate. [C]. Both run automatically. [D]. Both are stored in the database. Answer: Option A…