Free Access Oracle.1z1-071.v2025-05-13.q352 Practice Test (Page 19)

Question 86

The PRODUCTStable has the following structure.

Evaluate the following two SQL statements:
SQL>SELECT prod_id, NVL2 (prod_expiry_date, prod_expiry_date + 15, ' ') FROM products; SQL>SELECT prod_id, NVL (prod_expiry_date, prod_expiry_date + 15) FROM products; Which statement is true regarding the outcome?

A.Both the statements execute and give different results

B.Only the second SQL statement executes successfully

C.Both the statements execute and give the same result

D.Only the first SQL statement executes successfully

Question 87

Which two are true about the MERGE statement?

A.The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

B.The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

C.The WHEN MATCHED clause can be used to specify the inserts to be performed.

D.The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

E.The WHEN MATCHED clause can be used to specify the updates to be performed.

Question 88

Examine the description or the BOOKS_TRANSACTIONS table:

FOR customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND cust credit_level !=NULL;

B.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;

C.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level <> NULL
AND due_amount <> NULL;

D.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level !=NULL
AND due_amount !=NULL;

E.SELECT cust_first_name, cust_credit_limit * . 05 AS DUE AMOUNT
FROM customers
WHERE cust income_level IS NOT NULL
AND due_amount IS NOT NULL;

Question 89

View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

A.The statement executes successfully and produces the required output.

B.The statement produces an error because ITEM_CNTcannot be displayed in the outer query.

C.The statement produces an error because the GROUP BYclause cannot be used in a subquery in the FROM clause.

D.The statement produces an error because a subquery in the FROMclause and outer-joins cannot be used together.

Question 90

Which two queries will result in an error?

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

B.SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

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

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

E.SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;

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

Other Version: 4623Oracle.1z1-071.v2022-04-30.q200; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 252PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 362Nokia.4A0-113.v2026-05-01.q69; 397EC-COUNCIL.312-49v11.v2026-04-30.q214; 312Microsoft.MB-820.v2026-04-30.q101; 248Salesforce.MC-202.v2026-04-30.q57; 276BICSI.INSTC_V8.v2026-04-29.q53; 411NMLS.MLO.v2026-04-28.q82; 277NCARB.Project-Management.v2026-04-28.q27; 494EMC.D-AV-DY-23.v2026-04-27.q184; 1304ServiceNow.CSA.v2026-04-27.q483

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File