Free Oracle 1z0-071 Practice Test & Real Exam Questions

User HRhas CREATE SESSION, CREATE ANY TABLEand UNLIMITED TABLESPACE
privileges.
User SCOTThas CREATE SESSION, CREATE TABLEand UNLIMITED TABLESPACE
privileges.
HRsuccessfully executes this statement:

HRattempts to execute:
1. INSERT INTO scott.products VALUES (1, 'LAPTOP');
SCOTTattempts to execute:
2. SELECT * FROM products;
3. INSERT INTO scott.products VALUES (2, 'HDD');
4. CREATE SYNONYM prod FOR products;
Which will execute successfully?

You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value
102088. You executed the following SQL statement:
SELECT product_name, list_price
FROM product_information
WHERE (category_id = 12 AND category_id = 13)
AND supplier_id = 102088;
Which statement is true regarding the execution of the query?

See the Exhibit and examine the structure of the PROMOTIONS table:

Using the PROMOTIONS table,
you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

You are designing the structure of a table in which two columns have the specifications:
COMPONENT_ID - must be able to contain a maximum of 12 alphanumeric
characters and uniquely identify the row
EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute,
Second to the maximum precision and is used for calculations and
comparisons between components.
Which two options define the data types that satisfy these requirements most efficiently?

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.
Evaluate the following CREATE TABLE command:
CREATE TABLE new_orders(ord_id, ord_date DEFAULT SYSDATE, cus_id)
AS
SELECT order_id.order_date,customer_id
FROM orders;
Which statement is true regarding the above command?

View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

View the Exhibit and examine the structure of CUSTOMERStable.

Evaluate the following query:

Which statement is true regarding the above query?

View the Exhibit and examine the structure of the PRODUCTS table

Which two tasks would require subqueries? (Choose two.)

In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:

What would be the outcome?

Examine this statement which returns the name of each employee and their manager:

You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

You must create a table for a banking application.
One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.
3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid.
Which data type would you use?

View the Exhibit and examine the structure of the CUSTOMERStable.

CUSTOMER_VUis a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERStable.
CUSTOMERSneed to be updated to reflect the latest information about the customers.
What is the error in the following MERGEstatement?

Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.
Which query would give the required result?