← Back to exam page

Free 1z0-071 – Oracle Datbase 12c SQL Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 15 questions

Question 1

Which two statements are true regarding subqueries? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    A subquery can appear on either side of a comparison operator.
  • ○

    Only two subqueries can be placed at one level.
  • ○

    A subquery can retrieve zero or more rows.
  • ○

    A subquery can be used only in SQL query statements.
  • ○

    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.
Question 2

Examine the description of the ORDERS table:

Examine the description of the INVOICES table:

Examine this query:

Which three rows will it return? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    5 01-MAR-2019
  • ○

    3

  • ○

    1

  • ○

    4 01-FEB-2019
  • ○

    2

  • ○

    5

  • ○

    3 01-JAN-2019
Question 3

Which two statements are true regarding views? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
  • ○

    The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.
  • ○

    Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
  • ○

    Rows added through a view are deleted from the table automatically when the view is dropped.
  • ○

    A simple view in which column aliases have been used cannot be updated.
  • ○

    A subquery used in a complex view definition cannot contain group functions or joins.