Q. create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),primary key (ownerID:));Choose the correct option regarding the above statement (Solved)
1. The statement is syntactically wrong
2. It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
3. It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
4. It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.
- c. It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.