A           is a query that retrieves rows from more than one table or view:

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• Any recursive view must be defined as the union of two subqueries: a                query that is nonrecursive and a                      query.
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• Which view that contains more than one table in the top-level FROM clause of the SELECT statement:
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• Relational Algebra is a                      query language that takes two relations as input and produces another relation as an output of the query.
• Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
• Which SQL function is used to count the number of rows in a SQL query?
• Which of the following retains duplicate rows in the result of a query or in an Aggregate expression?