Exam 1z0-071 topic 1 question 83 discussion

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..

I think the question is what the result of intersect The result will only include rows where both the order_id and order_date match between the ORDERS and INVOICES tables. So, order ID 1& 4 has exact match -------- but the 4 1-Fab-2019 is not in result (if you dont consider the Typo in option F) B seems to be the answer in given circumstances

Best answer is B. 01-FEB-2019

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

La respuesta es la B y la F

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

Question is not there

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 ARE CORRECT

BF is the answer

I already took the exam ant these question ask for 3 answers B, E, F

Tesded: 1 null 4 01/02/19 00:00:00

BF is the answer

bf only if F is 01-FEB-2019 and not 01-FEB-2015 i am sorry then is B only

is t 100% bf went we do created everything

bf only if F is 01-FEB-2019 and not 01-FEB-2015