Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
sale

Want to Unlock All Questions for this Exam?

Full Exam Access, Discussions, No Robots Checks

Oracle 1z0-071 Exam Actual Questions

The questions for 1z0-071 were last updated on March 28, 2024.
  • Viewing page 1 out of 52 pages.
  • Viewing questions 1-5 out of 263 questions

Topic 1 - Single Topic

Question #1 Topic 1

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

  • A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
  • B. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
  • C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
  • D. SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;
  • E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
Reveal Solution Hide Solution   Discussion   11

Correct Answer: AC 🗳️

Question #2 Topic 1

Examine the description of the PRODUCTS table:

Which three queries use valid expressions? (Choose three.)

  • A. SELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;
  • B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
  • C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;
  • D. SELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;
  • E. SELECT product_id, expiry_date * 2 FROM products;
  • F. SELECT product_id, unit_price, unit_price + surcharge FROM products;
Reveal Solution Hide Solution   Discussion   17

Correct Answer: BCF 🗳️

Question #3 Topic 1

What is true about non-equijoin statement performance? (Choose two.)

  • A. The BETWEEN condition always performs less well than using the >= and <= conditions.
  • B. The BETWEEN condition always performs better than using the >= and <= conditions.
  • C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
  • D. Table aliases can improve performance.
  • E. The join syntax used makes no difference to performance.
Reveal Solution Hide Solution   Discussion   12

Correct Answer: DE 🗳️

Question #4 Topic 1

Which two are true? (Choose two.)

  • A. ADD_MONTHS adds a number of calendar months to a date.
  • B. CEIL requires an argument which is a numeric data type.
  • C. CEIL returns the largest integer less than or equal to a specified number.
  • D. LAST_DAY returns the date of the last day of the current month only.
  • E. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
  • F. LAST_DAY returns the date of the last day of the previous month only.
Reveal Solution Hide Solution   Discussion   19

Correct Answer: AC 🗳️
Reference:
https://docs.oracle.com/database/121/SQLRF/functions025.htm
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions004.htm

Question #5 Topic 1

Which three statements are true about Oracle synonyms? (Choose three.)

  • A. A synonym cannot be created for a PL/SQL package.
  • B. A synonym can be available to all users.
  • C. A SEQUENCE can have a synonym.
  • D. Any user can drop a PUBLIC synonym.
  • E. A synonym created by one user can refer to an object belonging to another user.
Reveal Solution Hide Solution   Discussion   5

Correct Answer: BCE 🗳️

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 ...