1z0-071 Exam - Question 74

Question

Examine the description of the BRICKS table:Examine the description of the BRICKS_STAGE table:Which two queries execute successfully? (Choose two. )A. B. C. D. E.

Examice · Accepted Answer

Based on the descriptions of the BRICKS and BRICKS_STAGE tables and the structure of the queries, the two queries that will execute successfully are A and D. These queries conform to the rules that both the number of columns and the data types of the columns being compared must match for a MINUS operation. The column names do not need to be identical, but the number and data types do. For query A: the first SELECT statement has 'brick_id' (NUMBER) and 'shape' (VARCHAR2), while the second SELECT statement has 'weight' (NUMBER) and 'color' (VARCHAR2). The data types do not match, so this query will not execute successfully. For query D: the first SELECT statement has 'shape' (VARCHAR2) and 'color' (VARCHAR2), and the second SELECT statement has 'color' (VARCHAR2) and 'shape' (VARCHAR2). Despite the different column order, both columns have matching data types, so this query will execute successfully.

Artur1991 · Answer

AD are the correct answers

paddy95 · Answer

A D
create table briks ( brick_id number(38)
                         , shape varchar2(30)
                         , color varchar2(30)
                         , weight number );

create table bricks_stage( weight number
                         , shape varchar2(30)
                         , color varchar2(30));
                         
   --A +                      
  select brick_id , shape from briks
  minus
  select weight, color from bricks_stage;
  
 --B -
select * from briks
  minus
select * from bricks_stage;

-- C -
  select shape, color from briks
  minus
  select weight, color from bricks_stage;
  
-- D +
  select shape, color from briks
  minus
  select color, shape from bricks_stage;
  
--E   
  select shape, color, weight from briks
  minus
  select * from bricks_stage;

Sushmasri · Answer

A,D are correct

Orxan_H · Answer

why C inccorect?

super04 · Answer

AD is Correct answer.
Use Minus operator to return all distinct rows selected by the first query, but not present in the second query result set. 
In Minus operator, the number of columns must be the same and data type of columns being selected by the SELECT statements in queries must belong to the same data type group in all the SELECT statements used in the query. The names of the columns, however, need not be identical.

Arth1989 · Answer

It is no brainer. AD!

HassanMkhlalati · Answer

AD are the correct

Arth1989 · Answer

AD, number of columns and order types should match

yaya32 · Answer

AD for me

Nelita · Answer

AD ARE CORRECT. The others show errors.

metallers · Answer

AD are the correct answers

Salmanbutt786 · Answer

I have tested A,D and E  these all are correct.

lucemqy · Answer

AD should be the correct answer since the data types match with same number of columns

Raja29 · Answer

AD are the correct answers

yanoolthecool · Answer

if D works, why wont E?

ArslanAltaf · Answer

AD is correct. The Data type and number of columns have to be same.

mage2611 · Answer

Answer is A, D is not correct because of the ordering of the columns (datatype mismatch)

1z0-071 Exam - Question 74

Discussion