A table can be logically connected to another table by defining a

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.
• 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):
• We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• 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:
• The                          scheme uses a page table containing pointers to all pages; the page table itself and all updated pages are copied to a new location.
• Drop Table cannot be used to drop a table referenced by a …………… constraint.
• Which of the following is an attribute that can uniquely identify a row in a table?
• Which of the following SQL command can be used to modify existing data in a database table?