Oracle Database SQL Free Sample Questions

Description

Covers database concepts, SELECT statements, filtering and sorting, aggregate and conversion functions, joins, subqueries, set operators, DML, DDL, views, privileges, and the data dictionary.

20 free sample questions505 in the full practice test

Try simulator

1z0-071 Sample Questions

  1. Question 1

    Examine the structure of the MEMBERS table below.

    Examine the SQL statement:
    SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC;

    What would be the result execution? (Choose the best answer.)

    Question 1 image
    Answer and explanation

    Correct answer: D

    D

  2. Question 2

    Multiple answers

    View the exhibit and examine the structure of the CUSTOMERS table.

    Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

    Question 2 image
    Answer and explanation

    Correct answers: A, E

    A, E

  3. Question 3

    You need to list the employees in DEPARTMENT_ID 20 days in a single row, ordered by HIRE_DATE

    Examine the sample output below.

    Which query will provide the required output?

    Question 3 image
    Answer and explanation

    Correct answer: B

    B

  4. Question 4

    Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

    Answer and explanation

    Correct answer: B

    B

  5. Question 5

    Multiple answers

    Which three statements are true about Structured Query Language (SQL)? (Choose three.)

    Answer and explanation

    Correct answers: A, D, E

    A, D, E

  6. Question 6

    Multiple answers

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

    Answer and explanation

    Correct answers: A, B, C

    A, B, C

  7. Question 7

    Multiple answers

    Which two statements best describe the benefits of using the WITH clause? (Choose two.)

    Answer and explanation

    Correct answers: A, B

    A, B

  8. Question 8

    Multiple answers

    Which two statements are true regarding the SQL GROUP BY clause? (Choose two.)

    Answer and explanation

    Correct answers: D, E

    D, E

  9. Question 9

    Examine the structure of the MEMBERS table.

    Which query can be used to display the last names and city names only for members from the states MO and Ml?

    Question 9 image
    Answer and explanation

    Correct answer: C

    C

  10. Question 10

    Examine the SQL statement used to create the TRANSACTION table.

    The value 'A1' does not exist for trn _ID in this table.

    Which SQL statement successfully inserts a row into the table with the default value for START_DATE?

    Question 10 image
    Answer and explanation

    Correct answer: C

    C

Register free for 10 more questions

Or unlock all 505 1z0-071 questions with explanations, timed mode and flashcards.