OMIS 452 Exam Questions with Correct Answers

OMIS 452 Exam Questions with Correct Answers

Save




Practice questions for this set


Learn 1 /7 Study with Learn




SQL can only query a single table.



Choose an answer



1 True 2 False



Don't know?




Terms in this set (85)


To remove duplicate rows TRUE
from the result of a query,
specify the SQL DISTINCT
keyword.

To refer to a set of values TRUE
needed for a condition,
use the SQL IN operator.

, To obtain all columns, use TRUE
an asterisk (*) wildcard
character instead of listing
all the column names.

SQL can only query a FALSE
single table.

Only two tables can be FALSE
queried by using a
subquery.

In an SQL query, which MAX
built-in function is used to
obtain the largest value of
numeric columns?

In an SQL query, which WHERE
SQL keyword is used to
state the condition that
specifies which rows are
to be selected?

When one SQL query is WHERE
embedded in another SQL
query, the second SQL
query is embedded in the
________ of the first query.

In an SQL query, which FROM
SQL keyword is used to
specify the table(s) to be
used?

A. data sublanguage
B. product of IBM research
C. national standard
SQL is a ________.
D. combination that include a data definition language
and a data manipulation language
CORRECT -> E. All of the above.