The                  keyword is used to access attributes of preceding tables or subqueries in the from clause.

Related MCQs

• Subqueries cannot:
• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Which of the following statements is true concerning subqueries?
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• The                  clause is used to list the attributes desired in the result of a query.
• Which of the following clause specifies the table or tables from where the data has to be retrieved?
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
• The main task carried out in the __________ is to remove repeating attributes to separate tables.
• A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.