Free Access Oracle.1z0-071.v2025-03-22.q314 Practice Test (Page 5)

Question 16

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable:

You want to display the CUST_NAMEvalues where the last name starts with Mcor MC.
Which two WHERE clauses give the required result? (Choose two.)

A.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) IN ('MC%', 'Mc%)

B.WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE 'Mc%'

C.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%'

D.WHERE SUBSTR (cust_name, INSTR (cust_name, '') +1) LIKE 'Mc%' OR 'MC%'

E.WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, '')+1)) LIKE UPPER ('MC%')

Question 17

Examine the create table statements for the stores and sales tables.
SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE); SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id)); You executed the following statement:
SQL> DELETE from stores
WHERE store_id=900;
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully?

A.Disable the primary key in the STORES table.

B.Use CASCADE keyword with DELETE statement.

C.DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.

D.Disable the FOREIGN KEY in SALES table and then delete the rows.

E.Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

Question 18

Which three statements are true about the DESCRIBE command?

A.It can be used to display the structure of an existing view.

B.It displays the NOT NULL constraint for any columns that have that constraint.

C.It can be used only from SQL*Plus.

D.It displays all constraints that are defined for each column.

E.It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

F.It can be used from SQL Developer.

Question 19

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 due_amount 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 IS NOT NULL
AND cust_credit_limit IS NOT NULL;

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

Question 20

Examine the description of the PRODUCTS table:

Which two statements execute without errors?

A.MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
DELETE WHERE (p.cost<200)

B.MERGE INTO new_prices n
USING (SELECT * FROM products) p
WHEN MATCHED THEN
UPDATE SET n.price= p.cost* 01
WHEN NOT MATCHED THEN
INSERT(n.prod_id, n.price) VALUES(p.prod_id, cost*.01)
WHERE(p.cost<200);

C.MERGE INTO new_prices n
USING products p
ON (p.prod_id =n.prod_id)
WHEN NOT MATCHED THEN
INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)
WHERE (p.cost<200);

D.MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id= p.prod_id)
WHEN MATCHED THEN
UPDATE SET n.price= p.cost*.01
DELETE WHERE (p.cost<200);

Premium Bundle

Newest 1z0-071 Exam PDF Dumps shared by BraindumpsPass.com for Helping Passing 1z0-071 Exam! BraindumpsPass.com now offer the updated 1z0-071 exam dumps, the BraindumpsPass.com 1z0-071 exam questions have been updated and answers have been corrected get the latest BraindumpsPass.com 1z0-071 pdf dumps with Exam Engine here:

Access 1z0-071 Premium Version

(437 Q&As Dumps, 40%OFF Special Discount: Exam-Tests)

Other Version: 7352Oracle.1z0-071.v2024-10-24.q196; 3577Oracle.1z0-071.v2023-10-02.q276; 2936Oracle.1z0-071.v2023-05-08.q154; 7363Oracle.1z0-071.v2022-09-21.q298; 6088Oracle.1z0-071.v2022-08-30.q239; 25794Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 175NAHQ.CPHQ.v2026-09-03.q481; 113SAP.C-S4CPB-2602.v2026-09-02.q7; 109Cisco.700-805.v2026-09-02.q86; 161MSSC.CLT-4.0.v2026-09-02.q43; 126Fitness.NCSF-CPT.v2026-09-02.q18; 174Google.Generative-AI-Leader.v2026-09-02.q77; 139PECB.ISO-14001-Lead-Auditor.v2026-09-01.q39; 126Google.GCP-DE.v2026-09-01.q27; 161Cisco.300-820.v2026-09-01.q105; 154Cisco.500-220.v2026-09-01.q72