Advanced Sql

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 of the above.

Answer: Option A

Explanation:

No answer description available for this question.

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 include the same number of columns.

[C].

Combines the output from multiple queries and must include the same number of columns.

[D].

Combines the output from multiple queries and does not include the same number of columns.

Answer: Option C

Explanation:

No answer description available for this question.

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 word SELECT.

[D].

All of the above.

Answer: Option A

Explanation:

No answer description available for this question.

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 a procedure.

[D].

Hard-coded SQL statements in a trigger.

Answer: Option A

Explanation:

No answer description available for this question.

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

Explanation:

No answer description available for this question.