Considering the SQL create statements; assume that SALE, SALE_ITEM and ITEM tables were created without Primary keys and Foreign Keys. Which of the following SQL statements gives an error? Select one: O a. Alter Table ITEM Add Primary key (ItemID); Alter Table SALE_ITEM Add Primary key (Saleld, SaleltemID); Alter Table SALE_ITEM Add Unique (SalelD); Alter Table ITEM Add Foreign Key (ItemID) References SALE_ITEM; O b. Alter Table SALE Add Primary key (SaleID); Alter Table SALE_ITEM Add Primary key (Saleld, SaleltemID); Alter Table SALE_ITEM Add Unique (SaleID); Alter Table ITEM Add Primary key (ItemID); Alter Table SALE Add Foreign Key (SalelD) References SALE_ITEM; O c. Alter Table SALE Add Primary key (SalelD); Alter Table SALE_ITEM Add Primary key (SalelD); Alter Table SALE Add Foreign Key (SalelD) References SALE_ITEM; O d. Alter Table SALE Add Primary key (SaleID); Alter Table SALE_ITEM Add Primary key (Saleld, SaleltemID); Alter Table SALE_ITEM Add Unique (SalelD); Alter Table SALE Add Foreign Key (SalelD) References SALE_ITEM (SalelD);



Answer :

Other Questions