create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),
primary key (ownerID:));
Choose the correct option regarding the above 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.
• Which key is referencing a primary key in a table:
• 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.
• A primary key when combined with a foreign key create
• 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
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
• Choose the correct statement regarding superkeys