Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 12)

Question 51

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

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

A.listing of customers who do not have a credit limit and were born before 1980

B.finding the number of customers, in each city, whose marital status is 'married'

C.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

D.listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'

E.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

Question 52

Examine the data in the CUST_NAMEcolumn of the CUSTOMERStable.
CUST_NAME
-------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC".
Which query gives the required output?

A.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
LIKE 'Mc%';

B.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
LIKE INITCAP ('MC%');

C.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
INITCAP 'MC%';

D.SELECT SUBSTR (cust_name, INSTR (cust_name, ' ')+1)
FROM customers
WHERE INITCAP (SUBSTR(cust_name, INSTR (cust_name, ' ')+1))
'Mc';

Question 53

Examine the description of the EMPLOYEES table:

Which two queries return the highest salary in the table?

A.SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

B.SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

C.SELECT MAX (salary)
FROM employees;

D.SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

E.SELECT MAX (salary)
FROM employees
GROUP BY department_id;

Question 54

Which three statements are true regarding single row subqueries?

A.They must return a row to prevent errors in the SQL statement.

B.They must be placed on the left side of the comparison operator or condition.

C.A SQL statement may have multiple single row subquery blocks.

D.They can be used in the HAVING clause.

E.They must be placed on the right side of the comparison operator or condition.

F.They can be used in the clause.

Question 55

Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraints_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output? (Choose two.)

A.The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.

B.In the second column, 'c' indicates a check constraint.

C.The STATUS column indicates whether the table is currently in use.

D.The R_CONSTRAINT_NAME column contains an alternative name for the constraint.

Premium Bundle

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

Access 1z1-071 Premium Version

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

Other Version: 4376Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 129Oracle.1z0-1195-26.v2026-10-19.q18; 140Salesforce.Salesforce-Slack-Administrator.v2026-10-19.q126; 168Salesforce.JS-Dev-101.v2026-10-19.q106; 203PaloAltoNetworks.SSE-Engineer.v2026-10-17.q44; 393Cisco.300-420.v2026-10-17.q324; 228Salesforce.MCE-Con-201.v2026-10-15.q108; 218EMC.NCA.v2026-10-15.q25; 317Apple.Apple-Device-Support.v2026-10-15.q159; 234F5.F5CAB3.v2026-10-14.q47; 219Oracle.1Z0-1048-25.v2026-10-14.q67