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

  • (A) The statement is syntactically wrong
  • (B) It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
  • (C) It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
  • (D) It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.
πŸ’¬ Discuss
βœ… Correct Answer: (C) It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
607
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
96%
Success Rate