_ A CASE SQL statement is which of the following?$? – McqOptions

MCQOPTIONS

1.	_ 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» B. A way to establish a loop in SQL.

Discussion

No Comment Found

Related MCQs

With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.~!
A function returns one value and has only output parameters.~!
A correlated subquery is where the outer query depends on data from the inner query.~!
Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.~!
The code to create triggers and routines is stored in only one location and is administered centrally.%!
The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.%!
Subqueries can be nested multiple times.%!
ROLLBACK WORK asks SQL to empty the log file.%!
There should be one condition within the WHERE clause for each pair of tables being joined.%!
The UNION clause is used to combine the output from multiple queries together into a single result table.%!