Question

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),
primary key (ownerID:));
Choose the correct option regarding the above statement

Accepted Answer

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

Answer

The statement is syntactically wrong

Answer

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

Answer

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

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

Discusssion

Related MCQs

Question analytics

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

Discusssion

Related MCQs

Question analytics

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