Create Table Apartmentownerid Varchar 5 Ownername Varchar25 #582
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));<br /> Choose the correct option regarding the above statement
This multiple choice question (MCQ) is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Introduction to Relational Model and SQL - Sql Data Definition - Quiz No.1.
create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));
Choose the correct option regarding the above statement
Choose the correct option regarding the above statement
The statement is syntactically wrong
It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.
