Access over 20 million homework & study documents
search

86) Which of the following is NOT true about using special operators

Content type

User Generated

Rating

Showing Page:
1/2
86) Which of the following is NOT true about using special
operators? A) Special operators are used to compare text
values using Find & Replace along with the AND operator.
B) Special operators are used to determine whether values
are between a range of values using the BETWEEN
operator.
C) Special operators are used in a set of values using the
IN operator.
D) Special operators are used to compare text values
using wildcards using the LIKE operator.
Solution
The IN conditional operator is really a set membership test
operator. That is, it is used to test whether or not a value
(stated before the keyword IN) is \"in\" the list of values
provided after the keyword IN.
For example:
This statement will select the employeeid, lastname, salary
from the employee_info table where the lastname is equal
to either: Hernandez, Jones, Roberts, or Ruiz. It will return
the rows if it is ANY of these values.
The IN conditional operator can be rewritten by using
compound conditions using the equals operator and

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/2

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

86) Which of the following is NOT true about using special operators? A) Special operators are used to compare text values using Find & Replace along with the AND operator. B) Special operators are used to determine whether values are between a range of values using the BETWEEN operator. C) Special operators are used in a set of values using the IN operator. D) Special operators are used to compare text values using wildcards using the LIKE operator. Solution The IN conditional operator is really a set membership test operator. That is, it is used to test whether or not a value (stated befor ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4