Examine the data in the INVOICES table: Examine the data in the CURRENCIES table: Which query returns the currencies in CURRENCIES that are not present in INVOICES? A. B. C. D.
For anyone confused A isn't gonna work because you didn't use aliases so its not comparing the right things.
Here is the correct query
create table invoices(
invoice_id number,
currency_code varchar2(10),
raised_date date
);
insert into invoices values(1, 'EUR', to_date('01-jan-2019'));
insert into invoices values(2, 'USD', to_date('01-feb-2019'));
insert into invoices values(3, 'JPY', to_date('01-mar-2019'));
create table currencies(
currency_code varchar2(10)
);
insert into currencies values('JPY');
insert into currencies values('GPD');
insert into currencies values('CAD');
insert into currencies values('EUR');
insert into currencies values('USD');
select *
from invoices;
select *
from currencies;
select *
from currencies c
where not exists (
select null from invoices i where i.currency_code = c.currency_code
);
D uses INTERSECT.
The Oracle INTERSECT operator compares the result of two queries and returns the distinct rows that are output by BOTH queries.
The question was to find the currecies only in ONE of the two tables. So C (MINUS)
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
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.
TheOracleWasTaken
Highly Voted 11 months, 2 weeks agobabyjaan
Most Recent 1 year, 1 month agoRik92
1 year, 1 month agoRik92
1 year, 5 months agoMahdiHamdii
1 year, 6 months ago