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 (*) )