Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

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.

Exam 1z0-882 topic 1 question 51 discussion

Actual exam question from Oracle's 1z0-882
Question #: 51
Topic #: 1
[All 1z0-882 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
ekpo
2 years, 9 months ago
Whe have a subquery present here...WHERE clause is absolutely perfect.
upvoted 1 times
...
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.

SaveCancel
Loading ...