Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

Related MCQs

• What type of join is needed when you wish to include rows that do not have matching values?
• What type of join is needed when you wish to include rows that do not have matching values?
• 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.
• What type of join is needed when you wish to return rows that do have matching values?
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• An                          consists of a search-key value and pointers to one or more records with that value as their search-key value.
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.
• The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is
• An ____________ consists of a search-key value and pointers to one or more records with that value as their search-key value.
• In a _______ clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.