OMIS 452 Ch 3 Questions and Answers

OMIS 452 Ch 3 Questions and Answers

Save




Terms in this set (25)


In SQL, to refer to a range of False
values in a WHERE clause, use
the WITHIN keyword.
T/F?

The ON DELETE CASCADE False
referential integrity constraint
does not apply when rows are
deleted using the SQL DELETE
command.
T/F?

When using SQL to create a False
table, specifying the NULL
property for a column indicates
that only null values may be
stored in that column.
T/F?

Microsoft Access can run QBE False
queries, but not SQL queries.
T/F?

Which of the following is not MODE
one of the five SQL built-in
functions?
a. AVG
b. SUM
c. MAX
d. COUNT
e. MODE

In SQL, the LIKE keyword can True
be combined with the NOT
keyword to form the NOT LIKE
condition for selecting values.
T/F?

, Given the table SELECT Name, PhoneNum
CUSTOMER(CustID, Name,
PhoneNum, AcctBalance)


what is the standard SQL query
phrase to retrieve the Name and
Phone Number of customers?
a.) SELECT (CUSTOMER-Name
AND CUSTOMER-PhoneNum)
b.) SELECT CUSTOMER-Name
AND CUSTOMER-PhoneNum
c.) SELECT Name, PhoneNum
d.) SELECT*
e.) SELECT (Name,PhoneNum)

The TOP built-in function in SQL False
is used to find the maximum
value in a numeric column.
T/F?

Microsoft Access SQL the SQL view of a Query window
commands are run in ________.
a. the SQL view of a Query
window
b. the SQL window
c. the QBE window
d. the Design View of a Query
window
e. the Query View of an SQL
window

To force the DBMS to remove True
duplicate rows from the results
of an SQL SELECT query, the
keyword DISTINCT must be
used.
T/F?

Standard SQL does not allow True
built-in functions to be used in a
WHERE clause.
T/F?