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 (
nameCHAR(30).
address CHAR(IOO) };


[A]
CREATE TABLE MovieStar (name StarType).
PI
CREATE TABLE MovieStar (name StarType PRIMARY KEY);
[C]
CREATE TABLE MovieStar OF StarType Q;
[D]
None of the others


Answer: C


Learn More :