What does the ALTER TABLE clause do?

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.
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• Which view that contains more than one table in the top-level FROM clause of the SELECT statement:
• Which of the following clause specifies the table or tables from where the data has to be retrieved?
• The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.
• 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.
• A table can be logically connected to another table by defining a