Download Oracle Database SQL.1z0-071.ActualTests.2021-06-07.78q.tqb

Download Exam

Files with TQB (Taurus Question Bank) extension can be opened by Taurus Exam Studio.

Download
Taurus Exam Studio

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

Demo Questions

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

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

Correct answer: AC

Examine the description of the PRODUCTS table:

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

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

Correct answer: BCF

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

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

Correct answer: DE

Which two are true? (Choose two.)

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