1z0-071 Practice Test

Review 272 1Z0-071 practice questions with answer explanations and community insights.

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

  1. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
  2. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
  3. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
  4. SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;
  5. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

Question 2

Examine the description of the PRODUCTS table: Which three queries use valid expressions? (Choose three.)

  1. SELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;
  2. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
  3. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;
  4. SELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;
  5. SELECT product_id, expiry_date * 2 FROM products;
  6. SELECT product_id, unit_price, unit_price + surcharge FROM products;

Question 3

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

  1. The BETWEEN condition always performs less well than using the >= and <= conditions.
  2. The BETWEEN condition always performs better than using the >= and <= conditions.
  3. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
  4. Table aliases can improve performance.
  5. The join syntax used makes no difference to performance.

Question 4

Which two are true? (Choose two.)

  1. ADD_MONTHS adds a number of calendar months to a date.
  2. CEIL requires an argument which is a numeric data type.
  3. CEIL returns the largest integer less than or equal to a specified number.
  4. LAST_DAY returns the date of the last day of the current month only.
  5. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
  6. LAST_DAY returns the date of the last day of the previous month only.

Question 5

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

  1. A synonym cannot be created for a PL/SQL package.
  2. A synonym can be available to all users.
  3. A SEQUENCE can have a synonym.
  4. Any user can drop a PUBLIC synonym.
  5. A synonym created by one user can refer to an object belonging to another user.