Exam 1z0-071 topic 1 question 185 discussion

Actual exam question from Oracle's 1z0-071

Question #: 185
Topic #: 1

Examine the description PRODUCTS table:

Examine the description of the NEW_PRODUCTS table:

Which two queries execute successfully?

A. SELECT prod_id FROM products -

UNION ALL -
SELECT prod_id, prod_name FROM new_products;
B. SELECT prod_id, exp_date FROM products

UNION ALL -
SELECT prod_id, NULL FROM new_products;
C. SELECT * FROM products -

MINUS -
SELECT prod_id, FROM new_products;
D. SELECT prod_id, prod_name FROM products

INTERSECT -
SELECT 100, prod_name FROM new_products;
E. SELECT * FROM products -

UNION -
SELECT * FROM new_products;

Show Suggested Answer

Suggested Answer: BE 🗳️

by SantiBZ_07032022_1744 at Feb. 19, 2023, 12:41 a.m.

Comments

Submit Cancel

SantiBZ_07032022_1744

Highly Voted 1 year, 10 months ago

B,E create table products (prod_id char(2), prod_name char(4), exp_date timestamp(6)); create table new_products (prod_id char(4), prod_name varchar2(10), exp_date DATE); /*A NOOK 01789. 00000 - "query block has incorrect number of result columns"*/ SELECT prod_id FROM products UNION ALL SELECT prod_id, prod_name FROM new_products; /*B OK.*/ SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id, NULL FROM new_products; /*C NOOK 01789. 00000 - "query block has incorrect number of result columns"*/ SELECT * FROM products MINUS SELECT prod_id FROM new_products; /*D NOOK 01790. 00000 - "expression must have same datatype as corresponding expression"*/ SELECT prod_id, prod_name FROM products INTERSECT SELECT 100, prod_name FROM new_products; /*E OK*/ SELECT * FROM products UNION SELECT * FROM new_products;

upvoted 6 times

...