Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-071

Free Oracle 1Z0-071 Exam Questions (page: 13)

Page 13 of 77
PDF with 380 Questions

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

  1. The NOT IN operator is equivalent to IS NULL.
  2. The <ANY operator means less than the maximum.
  3. =ANY and =ALL operators have the same functionality.
  4. The IN operator cannot be used in single-row subqueries.
  5. The NOT operator can be used with IN, ANY and ALL operators.

Answer(s): B,E



View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.

You are asked to retrieve the ORDER_ID, product_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.

You executed the following SQL statement:
SELECT prder_id, product_id, unit_price*quantity “Total Price”
FROM order_items
WHERE unit_price*quantity > 50000
NATURAL JOIN orders;

Which statement is true regarding the execution of the statement?

  1. The statement would execute and provide the desired result.
  2. The statement would not execute because the ON keyword is missing in the NATURAL JOIN clause.
  3. The statement would not execute because the WHERE clause is before the NATURAL JOIN clause.
  4. The statement would not execute because the USING keyword is missing in the NATURAL JOIN clause.

Answer(s): C



Which three tasks can be performed by DDL statements?

  1. providing an alternative name for a table
  2. modifying a table to prevent data that violate certain conditions from being entered in a column
  3. preventing any data modification to a table
  4. preventing data retrieval from a table outside of office hours
  5. creating multiple savepoints to enable partial rollback of a transaction

Answer(s): A,B,C



View the Exhibit and examine the data in EMP and DEPT tables.

In the DEPT table, DEPTNO is the PRIMARY KEY.

In the EMP table, EMPNO is the PRIMARY KEY and DEPTNO is the FOREIGN KEY referencing the DEPTNO column in the DEPT table.

What would be the outcome of the following statements executed in the given sequence?

DROP TABLE emp;

FLASHBACK TABLE emp TO BEFORE DROP;

INSERT INTO emp VALUES (2, ‘SCOTT’, 10);
INSERT INTO emp VALUES (3, ‘KING’, 55);

  1. Both the INSERT statements would fail because the constraints are automatically retrieved when the table is flashed back.
  2. Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.
  3. Only the first INSERT statement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.
  4. Only the SECOND INSERT statement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.

Answer(s): D



View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.



There is only one customer with the cust_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

  1. Option A
  2. Option B
  3. Option C
  4. Option D

Answer(s): A



Viewing page 13 of 77



Post your Comments and Discuss Oracle 1Z0-071 exam prep with other Community members:

1Z0-071 Exam Discussions & Posts