__To define what columns should be displayed in an SQL SELECT statemen – McqOptions

MCQOPTIONS

1.	__To define what columns should be displayed in an SQL SELECT statement:__
A.	use FROM to name the source table(s) and list the columns to be shown after SELECT.
B.	use USING to name the source table(s) and list the columns to be shown after SELECT.
C.	use SELECT to name the source table(s) and list the columns to be shown after USING.
D.	use USING to name the source table(s) and list the columns to be shown after WHERE.
Answer» B. use USING to name the source table(s) and list the columns to be shown after SELECT.

Discussion

No Comment Found

Related MCQs

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.~!
To establish a range of values, < and > can be used.~!
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.~!
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.~!
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.~!
Indexes can usually be created for both primary and secondary keys.~!
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.%!
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.%!
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.%!
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.%!