1z0-071 Practice Test

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

Question 26

Which three statements are true about single-row functions? (Choose three.)

  1. They return a single result row per table.
  2. They can be nested to any level.
  3. They can accept only one argument.
  4. The argument can be a column name, variable, literal or an expression.
  5. They can be used only in the WHERE clause of a SELECT statement.
  6. The data type returned can be different from the data type of the argument.

Question 27

Which two statements are true about *_TABLES views? (Choose two.)

  1. USER_TABLES displays all tables owned by the current user.
  2. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.
  3. All users can query DBA_TABLES successfully.
  4. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES.
  5. ALL_TABLES displays all tables owned by the current user.
  6. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.

Question 28

Which two statements are true about conditional INSERT ALL? (Choose two.)

  1. Each row returned by the subquery can be inserted into only a single target table.
  2. A single WHEN condition can be used for multiple INTO clauses.
  3. Each WHEN condition is tested for each row returned by the subquery.
  4. It cannot have an ELSE clause.
  5. The total number of rows inserted is always equal to the number of rows returned by the subquery.

Question 29

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

  1. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.
  2. It can only be used for NUMBER data types.
  3. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.
  4. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column
  5. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

Question 30

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?

  1. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
  2. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
  3. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
  4. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;