1z0-071 topic 1 question 83

drop table orders;
create table orders(order_id number , order_date date);

insert into orders values(1,null);
insert into orders values(2,null);
insert into orders values(3,'1-jan-2019');
insert into orders values(4,'1-feb-2019');
insert into orders values(5,'1-mar-2019');

create table invoices(
invoice_id number, order_id number, order_date date);

insert into invoices values(1,1,null);
insert into invoices values(2,2,'01-jan-2019');
insert into invoices values(3,3,null);
insert into invoices values(4,4,'01-feb-2019');
insert into invoices values(5,5,'01-APR-2019');

SELECT ORDER_ID , ORDER_DATE FROM ORDERS
INTERSECT
SELECT ORDER_ID , ORDER_DATE FROM INVOICES;

ANSWER IS B,F.

This needs an update badly. There is no question, just some tables and a query showing on this site..

Just finished this exam. Question: Which three results will be returned?

B and F is answer- below is the result we will get. F option has typo 01-FEB-2019
orderid  order_date
1          (null)
4          01-02-19

In Oracle, the INTERSECT operator is used to combine the result sets of two or more SELECT statements and returns only the rows that are common to all result sets.

BF is the answer

can you write to me on telegram @Melsson

BF is the answer

is t 100% bf went we do created everything