Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Consider the structures of the country and countrylanguage tables. mysql >DESCRIBE country; mysql> DESCRIBE countrylanguage;
Which query will give you the list of all European countries where German is spoken?
A.
SELECT Code AS c, Name FROM Country WHERE Continent = Europe AND EXISTS ( SELECT * FROM CountryLanguage WHERE CountryCode = Code And Language= German )
B.
SELECT Code AS c, Name FROM Country WHERE Continent = Europe AND Name IN ( SELECT * FROM CountryLanguage WHERE CountryCode = Code AND Language =German )
C.
SELECT Code AS c, Name FROM Country WHERE Continent = Europe AND EXIST ANY ( SELECT Language, CountryCode FROM CountryLanguage WHERE CountryCode =Code AND Language = German )
D.
SELECT Code AS c, Name FROM Country WHERE Continent = Europe AND ( SELECT * FROM CountryLanguage WHERE CountryCode =Code AND Language =German
Whe have a subquery present here...WHERE clause is absolutely perfect.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ekpo
2 years, 9 months ago