ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-061 All Questions

View all questions & answers for the 1z0-061 exam
Go to Exam

Exam 1z0-061 topic 3 question 16 discussion

Actual exam question from Oracle's 1z0-061
Question #: 16
Topic #: 3
[All 1z0-061 Questions]

View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.

You need to generate a report showing the promo name along with the customer name for all products that were sold during their promo campaign and before
30th October 2007.
You issue the following query:

Which statement is true regarding the above query?

  • A. It executes successfully and gives the required result.
  • B. It executes successfully but does not give the required result.
  • C. It produces an error because the join order of the tables is incorrect.
  • D. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Sugar at Aug. 4, 2019, 2:58 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
hggz
5 years, 6 months ago
B is correct. You can check this: create table q16_promotions( promo_id number(2) not null, promo_name varchar2(10), promo_cat varchar2(10), promo_cost number(8,2), promo_begin_date date, promo_end_date date); create table q16_sales( prod_id number(3) not null, promo_id number(3) not null, time_id date, qty_sold number(6,2), cust_id number(2) not null); create table q16_customer( cust_id number(3) not null, cust_name varchar2(20), cust_address varchar2(30)); select promo_name, cust_name from q16_promotions p join q16_sales s on(time_id between promo_begin_date and promo_end_date) join q16_customer c on (s.cust_id = c.cust_id) and time_id < '30-oct-2007';
upvoted 1 times
hggz
5 years, 6 months ago
And that SELECT dont return row where promo_begin_date or promo_end_date or time_id is NULL.
upvoted 1 times
...
...
Sugar
5 years, 8 months ago
this query will not run successfully
upvoted 1 times
...
Sugar
5 years, 8 months ago
C is the answer
upvoted 1 times
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago