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

Question 196

The customers table has the following structure:
You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

A.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level <> NULL ANDtax_amount <> NULL;

B.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDtax_amount IS NOT NULL;

C.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE cust_income_level IS NOT NULL ANDcust_credit_limit IS NOT NULL;

D.SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNTFROM customersWHERE (cust_income_level, tax_amount) IS NOT NULL;

Question 197

Which two statements execute successfully?

A.SELECT TO _ CHAR (TO_ DATE ('2019-DEC-25 03:30','YYYY-MON-DD HH12:MI')) FROM DUAL

B.SELECT TO _DATE (TO_ CHAR ('2019-DEC-25 03:30', 'YYYY-MON-DD HH12:MI')) FROM DUAL;

C.SELECT TO_ DATE('2019-DEC-25 15:30', 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE
=AMERICAN' ) FROM DUAL;

D.SELECT TO_CHAR('2019-DEC-25 15:30", YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE = AMERICAN') FROM DUAL;

E.SELECT TO _ CHAR ('2019-DEC-25 15:30'.'YYYY-MON-DD HH24:MI') FROM DUAL

Question 198

Which statement is true about aggregate functions?

A.The AVG function implicitly converts NULLSto zero.

B.Aggregate functions can be nested to any number of levels.

C.The MAXand MINfunctions can be used on columns with character data types.

D.Aggregate functions can be used in any clause of a SELECTstatement.

Question 199

Examine the description of EMPLOYEES table:
Which three queries return all rows for which SALARY+COMMISSION is greate than 20000?

A.SELECT * FROM employees WHERE salary+NULLF(commission,0)>=20000;

B.SELECT * FROM employees WHERE NVL(salary+commission,0)>==20000;

C.SELECT * FROM employees WHERE salary+NVL2(commission,commission,0)>=20000;

D.SELECT * FROM employees WHERE NVL(salary+commission,0)>=20000;

E.SELECT * FROM employees WHERE NVL2(salary)+commission,salary+commission,

F.SELECT * FROM employees WHERE salary+NVL(commission,0)>=20000;

Question 200

View the exhibits and examine the structures of the COSTSand PROMOTIONStables.

Evaluate the following SQL statement:

What would be the outcome of the above SQL statement?

A.It displays prod IDs in the promos which cost less than the highest cost in the same time interval.

B.It displays prod IDs in the promo with the lowest cost.

C.It displays prod IDs in the promos with the highest cost in the same time interval.

D.It displays prod IDs in the promos with the lowest cost in the same time interval.

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

Latest Upload: 257PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 366Nokia.4A0-113.v2026-05-01.q69; 402EC-COUNCIL.312-49v11.v2026-04-30.q214; 319Microsoft.MB-820.v2026-04-30.q101; 250Salesforce.MC-202.v2026-04-30.q57; 294BICSI.INSTC_V8.v2026-04-29.q53; 421NMLS.MLO.v2026-04-28.q82; 281NCARB.Project-Management.v2026-04-28.q27; 500EMC.D-AV-DY-23.v2026-04-27.q184; 1319ServiceNow.CSA.v2026-04-27.q483

Question 196

Question 197

Question 198

Question 199

Question 200

Download PDF File