1z0-071 Practice Test

1z0-071 Practice Test practice questions, page 5 of 11, with answer review and explanations.

Question 21

Which two are true about unused columns? (Choose two.)

  1. A query can return data from unused columns, but no DML is possible on those columns.
  2. Unused columns retain their data until they are dropped.
  3. Once a column has been set to unused, a new column with the same name can be added to the table.
  4. The DESCRIBE command displays unused columns.
  5. A primary key column cannot be set to unused.
  6. A foreign key column cannot be set to unused.

Question 22

Which two are true about the precedence of operators and conditions? (Choose two.)

  1. || has a higher order of precedence than + (addition).
  2. + (addition) has a higher order of precedence than * (multiplication).
  3. NOT has a higher order of precedence than AND and OR in a condition.
  4. AND and OR have the same order of precedence in a condition.
  5. Operators are evaluated before conditions.

Question 23

In your session, the NLS_DATE_FORMAT is DD-MM-YYYY. There are 86400 seconds in a day. Examine this result: DATE - ----------- 02-JAN-2020 Which statement returns this?

  1. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  2. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  3. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;
  4. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON- YYYY') AS "date" FROM DUAL;
  5. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Question 24

Examine the data in the INVOICES table: Examine the data in the CURRENCIES table: Which query returns the currencies in CURRENCIES that are not present in INVOICES? A. B. C. D.

Question 25

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully? (Choose two.)

  1. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY COUNT(*) > 10;
  2. SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(*) > 10;
  3. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
  4. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;
  5. SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;