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

Question 191

Examine the structure of the BOOKS_TRANSACTIONS table:

You want to display the member IDs, due date, and late fee as $2 for all transactions.
Which SQL statement must you execute?

A.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

B.SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

C.SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

D.SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

Question 192

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

Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?

A.SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT"FROM customers;

B.SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT"FROM customers;

C.SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT"FROM customers;

D.SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT"FROM customers;

Question 193

The SALES table has columns PROD_IDand QUANTITY_SOLDof data type NUMBER.
Which two queries execute successfully? (Choose two.)

A.BY COUNT(*) >10;
SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;

B.COUNT(*) >10;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP

C.SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING

D.prod_id;
SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP

E.BY prod_id HAVING COUNT(*) >10;
SELECT COUNT (prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY

Question 194

Which three statements are true about multiple-row subqueries?

A.They can return only one column but multiple rows.

B.They can return multiple columns as well as rows.

C.They can contain group functions and GROUP BYand HAVINGclauses.

D.They cannot contain a subquery within a subquery.

E.They can contain group functions and the GROUP BYclause, but not the HAVINGclause.

F.They can contain a subquery within a subquery.

Question 195

You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

A.In generates an error because rrrrshould be replaced by rrin the format string.

B.In generates an error because TO_CHARshould be replaced with TO_DATE.

C.In generates an error because fmand double quotation marks should not be used in the format string.

D.It executes successfully and returns the correct result.

E.It executes successfully but does not return the correct result.

Other Version: 4124Oracle.1z0-071.v2025-03-22.q314; 7454Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25883Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 122Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 208Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 191

Question 192

Question 193

Question 194

Question 195

Download PDF File