exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 79 discussion

Actual exam question from Oracle's 1z0-082
Question #: 79
Topic #: 1
[All 1z0-082 Questions]

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

  • A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
  • B. Display suppliers whose PROD_LIST_PRICE is less than 1000
  • C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
  • D. Display the total number of products supplied by supplier 102 which have a product status of obsolete
  • E. Display the minimum PROD_LIST_PRICE for each product status
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
Ekos
Highly Voted 3 years, 6 months ago
i agree, A & C is the correct answer
upvoted 11 times
...
mamadu
Most Recent 12 months ago
True A & C A. select * from products where PROD_LIST_PRICE > (select AVG(PROD_LIST_PRICE) from products); B. select SUPPLIER_ID from products where PROD_LIST_PRICE < 1000; C. select * from products where PROD_LIST_PRICE > (select AVG(PROD_LIST_PRICE) from products) and PROD_STATUS = 'orderable'; D. select * from products where SUPPLIER_ID = 102 and PROD_STATUS = 'obsolete'; E. select MIN(PROD_LIST_PRICE) from products group by PROD_STATUS;
upvoted 1 times
...
LeandroHPN
1 year, 12 months ago
Selected Answer: AC
A e C is correct.
upvoted 1 times
...
algerianphoenix
2 years, 1 month ago
AC, correct answer by testing.
upvoted 1 times
...
iamajavacompiler
3 years, 2 months ago
Why is D wrong?
upvoted 1 times
leozanon94
3 years, 1 month ago
Select * from products where supplier_id = 102 And prod_status = 'obsolete';
upvoted 3 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
Loading ...