The DROP TABLE statement:

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.
• Drop Table cannot be used to drop a table referenced by a                    constraint.
• 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.
• A table can be logically connected to another table by defining a
• Which view that contains more than one table in the top-level FROM clause of the SELECT statement:
• The statement in SQL which allows to change the definition of a table is
• create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID:)); Choose the correct option regarding the above statement
• Which CREATE TABLE statement is valid?