Which key is referencing a primary key in a table:

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.
• 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.
• 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.
• 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.
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
• The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
• 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:
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID:)); Choose the correct option regarding the above statement