Exam 1z0-071 topic 1 question 146 discussion

Actual exam question from Oracle's 1z0-071

Question #: 146
Topic #: 1

Examine the description of the BOOKS table:

Examine these requirements:

1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.
2. Sort the titles by date of purchase, starting with the most recently purchased book.

Which two queries can be used? (Choose two.)

Show Suggested Answer

Suggested Answer: CE 🗳️

by jfc1 at Feb. 15, 2023, 4:51 p.m.

Comments

Submit Cancel

Jonastech

10 months, 2 weeks ago

I executed commands, correct are CE.

upvoted 1 times

...

ArslanAltaf

1 year, 2 months ago

B&D can be eliminated straight away by looking at the ORDER BY AESC because the question states that the highest date should be first which means DESC should be used with the column PURCHASE_DATE Rule out A because of syntax error in OR operator usage C & D is correct

upvoted 1 times

ArslanAltaf

1 year, 2 months ago

Correction C & E is correct Answer

upvoted 1 times

...

[Removed]

1 year, 3 months ago

where (price < 500 or >1000) it is not correct. where (price <500 or price >1000) it is correct. CE correct answer

upvoted 1 times

...

yaya32

1 year, 5 months ago

Selected Answer: CE

CE is correct

upvoted 2 times

...

Mcromeo

1 year, 6 months ago

Selected Answer: CE

A gives error because of > 1000

upvoted 1 times

...

lucemqy

1 year, 7 months ago

CE is correct A have incorrect syntax

upvoted 2 times

...

MooonLight

2 years, 2 months ago

CE is correct. A - where condition should have 'price' as well for 1000 B - where condition 'between 500 and 1000' does not satisfy what is asked; 'order by' clause's default is ascending D - where condition 'price IN (500,1000)' and order by ASC is wrong

upvoted 2 times

...