You wish to create the table CountryLanguage which will contain the languages spoken in each country across the world. All combinations of Country and Language should be unique. Which of the following CREATE statements are the correct way of specifying the table?
A.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL PRIMARY KEY, Language CHAR(30) NOT NULL PRIMARY KEY )
B.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL, Language CHAR(30) NOT NULL, PRIMARY KEY (Country, Language) )
C.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL, Language CHAR(30) NOT NULL, PRIMARY KEY (*) )
D.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL UNIQUE, Language CHAR(30) NOT NULL UNIQUE )
E.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL, Language CHAR(30) NOT NULL, UNIQUE (Country, Language))
F.
CREATE TABLE CountryLanguage ( Country CHAR(30) NOT NULL, Language CHAR(30) NOT NULL, UNIQUE (*) )