Oracle 1z0-071 Exam Actual Questions

• 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;

• 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;

• F. SELECT product_id, unit_price, unit_price + surcharge FROM products;

Which two statements are true about the COUNT function? (Choose two.)

• A. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

• B. It can only be used for NUMBER data types.

• C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

• D. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.Which query can be used?

• A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

• B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

• C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

• D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A. It displays values for variables used only in the WHERE clause of a query.

• B. It displays values for variables created by the DEFINE command.

• C. It can be used only in SQL*Plus.

• D. It displays values for variables prefixed with &&.

• E. It can be used in SQL Developer and SQL*Plus.

You start a session and execute these commands successfully:Which two are true? (Choose two.)

• A. To drop the table in this session, you must first truncate it.

• B. Other sessions can view the committed row.

• C. You can add a column to the table in this session.

• D. When you terminate your session, the row will be deleted.

  Hide Solution