Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 19)

Question 86

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

Which two SQL statements would execute successfully? (Choose two.)

A.SELECT AVG(inv_date)
FROM invoice

B.SELECT MAX(inv_date), MIN(cust_id)
FROM invoice

C.SELECT MAX(AVG(SYSDATE -inv_date))
FROM invoice

D.SELECT AVG( inv_date -SYSDATE), AVG(inv_amt)
FROM invoice

Question 87

Which two queries will result in an error?

A.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY ANNUAL_SALARY;

B.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY 12 * SALARY;

C.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

D.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE ANNUAL_SALARY > 100000
ORDER BY 12 * SALARY ;

E.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;

F.SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY
FROM EMPLOYEES
WHERE 12 * SALARY > 100000
ORDER BY ANNUAL_SALARY;

Question 88

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?

A.It generates an error because multiple conditions cannot be specified for the WHEN clause.

B.It executes successfully and gives the required result.

C.It generates an error because CASE cannot be used with group functions.

D.It generates an error because NULL cannot be specified as a return value.

Question 89

View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

A.SELECT order_id, order_date FROM orders
WHERE order_date >
ANY
(SELECT order_date FROM orders WHERE customer_id = 101);

B.SELECT order_id, order_date FROM orders
WHERE order_date > IN
(SELECT order_date FROM orders WHERE customer_id = 101);

C.SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;

D.SELECT order_id, order_date FROM orders
WHERE order_date > ALL
(SELECT order_date FROM orders WHERE customer_id = 101);

Question 90

View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

A.ALTER TABLE orders
MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

B.ALTER TABLE orders
ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

C.ALTER TABLE orders
ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

D.ALTER TABLE orders
MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

Other Version: 4129Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3041Oracle.1z0-071.v2023-05-08.q154; 7493Oracle.1z0-071.v2022-09-21.q298; 25889Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 131Adobe.AD0-E911.v2026-09-12.q35; 123Google.ADP.v2026-09-11.q22; 140AIChE.CCPSC.v2026-09-11.q41; 131Scrum.PSPO-III.v2026-09-10.q23; 221Scrum.PSPO-I.v2026-09-09.q157; 189ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 221Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 171BCI.CBCI.v2026-09-07.q89; 214Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File