Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-071

Oracle 1Z0-071 Exam (page: 15)
Oracle Database SQL
Updated on: 01-Sep-2025

Viewing Page 15 of 77
1Z0-071 PDF 380 Questions

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.



Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

  1. It displays prod IDs in the promo with the lowest cost.
  2. It displays prod IDs in the promos with the lowest cost in the same time interval.
  3. It displays prod IDs in the promos with the highest cost in the same time interval.
  4. It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

Answer(s): D



View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.


You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.

Which SQL statement would you execute to accomplish the task?

  1. UPDATE dept d
    SET city = ALL (SELECT city
    FROM locations 1
    WHERE d.location_id = l.location_id);
  2. UPDATE dept d
    SET city = (SELECT city
    FROM locations 1)
    WHERE d.location_id = l.location_id;
  3. UPDATE dept d
    SET city = ANY (SELECT city
    FROM locations 1)
  4. UPDATE dept d
    SET city = (SELECT city
    FROM locations 1
    WHERE d.location_id = 1.location_id);

Answer(s): D



The BOOKS_TRANSACTIONS table exists in your schema in this database.

You execute this SQL statement when connected to your schema in your database instance.
SQL> SELECT * FROM books_transactions ORDER BY 3;

What is the result?

  1. The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.
  2. All table rows are displayed sorted in ascending order of the values in the third column.
  3. The first three rows in the table are displayed in the order that they are stored.
  4. Only the three rows with the lowest values in the key column are displayed in the order that they are stored.

Answer(s): B



Which statement is true about Data Manipulation Language (DML)?

  1. DML automatically disables foreign ley constraints when modifying primary key values in the parent table.
  2. Each DML statement forms a transaction by default.
  3. A transaction can consist of one or more DML statements.
  4. DML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.

Answer(s): C



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


You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the ‘INTERNET’ category.

Which query would give you the required output?

  1. SELECT promo_name, promo_begin_date FROM promotions
    WHERE promo_begin_date> ALL (SELECT MAX (promo_begin_date)
    FROM promotions) AND
    promo_category= ‘INTERNET’;
  2. SELECT promo_name, promo_begin_date FROM promotions
    WHERE promo_begin_date IN (SELECT promo_begin_date
    FROM promotions
    WHERE promo_category= ‘INTERNET’);
  3. SELECT promo_name, promo_begin_date FROM promotions
    WHERE promo_begin_date > ALL (SELECT promo_begin_date
    FROM promotions
    WHERE promo_category = ‘INTERNET’);
  4. SELECT promo_name, promo_begin_date FROM promotions
    WHERE promo_begin_date> ANY (SELECT promo_begin_date
    FROM promotions

    WHERE promo_category= ‘INTERNET’);

Answer(s): C



Viewing Page 15 of 77



Share your comments for Oracle 1Z0-071 exam with other users:

Saravana Kumar TS 12/8/2023 9:49:00 AM

question: 93 which statement is true regarding the result? sales contain 6 columns and values contain 7 columns so c is not right answer.
INDIA