Select the SQL query that would create the table LINE illustrated below, when the query is executed.

LINE

Inv$\_$No $($PK$)\{$FK$1\}$

Line$\_$No$($Pk$)$

P$\_$No$\{$FK$\}$

Line$\_$Units

Line$\_$Price

A$.$ CREATE TABLE LINE

Inv$\_$No NUMBER NOT NULL,

Line$\_$No NUMBER$(2,0)$ NOT NULL,

P$\_$No VARCHAR$(10)$ NOT NULL,

Line$\_$Units NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

Line$\_$Price NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

PRIMARY KEY$($Inv$\_$No$,$ Line$\_$No$),$

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES INVOICE SET DEFAULT,

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES PRODUCT$($P$\_$No$),$

CONSTRAINT Line$\_$UI$1$ UNIQUE$($Inv$\_$No$,$ P$\_$No$)$;

$14$ HDBP$200-1-$Jan$-$Jun$2024-$SA$1-$Revision$-20052024$

B$.$ CREATE TABLE LINE

Inv$\_$No NUMBER NOT NULL,

Line$\_$No NUMBER$(2,0)$ NOT NULL,

P$\_$No VARCHAR$(10)$ NOT NULL,

Line$\_$Units NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

Line$\_$Price NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

PRIMARY KEY$($Inv$\_$No$,$ Line$\_$No$),$

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES INVOICE UNIQUE,

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES PRODUCT$($P$\_$No$),$

CONSTRAINT Line$\_$UI$1$ UNIQUE$($Inv$\_$No$,$ P$\_$No$)$;

C$.$ CREATE TABLE LINE

Inv$\_$No NUMBER NOT NULL,

Line$\_$No NUMBER$(2,0)$ NOT NULL,

P$\_$No VARCHAR$(10)$ NOT NULL,

Line$\_$Units NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

Line$\_$Price NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

PRIMARY KEY$($Inv$\_$No$,$ Line$\_$No$),$

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES INVOICE ON DELETE CASCADE,

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES PRODUCT$($P$\_$No$),$

CONSTRAINT Line$\_$UI$1$ UNIQUE$($Inv$\_$No$,$ P$\_$No$)$;

D$.$ CREATE TABLE LINE

Inv$\_$No NUMBER NOT NULL,

Line$\_$No NUMBER$(2,0)$ NOT NULL,

P$\_$No VARCHAR$(10)$ NOT NULL,

Line$\_$Units NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

Line$\_$Price NUMBER$(9,2)$ DEFAULT $0\mathrm{.}00$ NOT NULL,

PRIMARY KEY$($Inv$\_$No$,$ Line$\_$No$),$

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES INVOICE NOT NULL,

FOREIGN KEY$($Inv$\_$No$)$ REFERENCES PRODUCT$($P$\_$No$),$

CONSTRAINT Line$\_$UI$1$ UNIQUE$($Inv$\_$No$,$ P$\_$No$)$;