1. Computer Science Engineering (CSE)
  2. DataBase Management System (DBMS)
  3. Relational Modal
  4. create table apartment(ownerID varchar (...
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.
Answer» C. It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

Discussion