Free Access Oracle.1z0-071.v2023-10-02.q276 Practice Test (Page 54)

Question 261

You execute the SQL statement:

What is the outcome?

A.It fails because the NOT NULL and DEFAULToptions cannot be combined for the same column.

B.It fails because the condition for the CNAMESconstraint is not valid.

C.It succeeds and an index is created for CITIZEN_ID.

D.It It succeeds and CITYcan contain only 'SEATTLE'or null for all rows.

Question 262

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 due_amount !=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 cust credit_level !=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 263

View the Exhibit and examine the structure of the ORDERStable.

Which UPDATE statement is valid?
UPDATE orders

A.SET order_date = ’12-mar-2007’,
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;
UPDATE orders

B.SET order_date = ’12-mar-2007’,
order_total IS NULL
WHERE order_id = 2455;
UPDATE orders

C.SET order_date = ’12-mar-2007’,
order_total = NULL
WHERE order_id = 2455;
UPDATE orders

D.SET order_date = TO_DATE(’12-mar-2007’,’dd-mon-yyyy’),
SET order_total = TO_NUMBER (NULL)
WHERE order_id = 2455;

Question 264

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 TO_CHAR(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 NVL (cust_credit_limit*.15, 'Not Available') "NEW CREDIT" FROM customers

Question 265

View the exhibit and examine the structure of the PROMOTIONS table.
You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

A.SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE
promo_category= 'INTERNET');

B.SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions)
ANDpromo_category= 'INTERNET';

C.SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE
promo_category = 'INTERNET');

D.SELECT promo_name, promo_begin_date FROM promotionsWHERE
promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE
promo_category= 'INTERNET');

Other Version: 3116Oracle.1z0-071.v2025-03-22.q314; 6656Oracle.1z0-071.v2024-10-24.q196; 2608Oracle.1z0-071.v2023-05-08.q154; 6661Oracle.1z0-071.v2022-09-21.q298; 5485Oracle.1z0-071.v2022-08-30.q239; 25224Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 296Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 209Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 333NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 461EMC.D-AV-DY-23.v2026-04-27.q184; 1113ServiceNow.CSA.v2026-04-27.q483

Question 261

Question 262

Question 263

Question 264

Question 265

Download PDF File