Question Regarding Topic for 1Z0-117
I'm preparing for the exam 1Z0-117: Oracle Database 11g Release 2: SQL Tuning
One of the topics is "Describe the SQL Operators for Tables and Indexes" and I'm trying to determine specifically what Oracle Education means by that. There are any number of operators:
Comparison Operators
=
!=, ^=, <>
<
<=
...
Arithmetic Operators
+ (unary)
- (unary)
/
*
+
-
Logical Operators
NOT
AND
OR
JOIN operators
INNER
LEFT OUTER
RIGHT OUTER
FULL OUTER
CROSS
Set Operators
UNION
UNION ALL
INTERSECT
MINUS
However, it seems weird to me to specifically mention them in relation to 'Tables and Indexes'. I can see the actions that the SET operators have in combining the SQL results from two queries (which may be different tables). Obviously the JOIN operators relate to tables. The comparison and logical operators used in a WHERE clause determine whether or not an index can be used, and how effective it is.
All of this seems to be reaching a bit to me, though. Does anyone else have an idea what they might be looking for on this topic?