Select the right statement to declare MovieStar to be a relation whose tuples are of type StarType. Note: StarType is a user-defined type that has its definition as follows:

Select the right statement to declare MovieStar to be a relation whose tuples are of type StarType. Note: StarType is a user-defined type that has its definition as follows:

CREATE TYPE StarType AS
(
name CHAR(30),
address CHAR(100)
);



a. CREATE TABLE MovieStar (name StarType );
b. CREATE TABLE MovieStar (name StarType PRIMARY KEY );
c. CREATE TABLE MovieStar OF StarType ();
d. None of the others




Answer: C


Learn More :